PQH EEO5 Reporting

Description
Categories: BI Publisher
Columns: Employment Category, Job Category Name, Cons Total Category Emps, No Cons Wmale Emps, No Cons Bmale Emps, No Cons Hmale Emps, No Cons Amale Emps, No Cons Imale Emps, No Cons Wfemale Emps, No Cons Bfemale Emps ...
Application: Public Sector HR
Source: EEO5 Reporting (XML)
Short Name: PQHEEO5_XML
DB package: PQH_PQHEEO5_XMLP_PKG
SELECT  	decode(pqh_employment_category.identify_empl_category(ass.employment_category,:cp_fr,:cp_ft,:cp_pr,:cp_pt),
          	'FR', 'A. FULL TIME STAFF',  'B. PART-TIME STAFF') employment_category,
decode(pqh_employment_category.identify_empl_category(ass.employment_category,:cp_fr,:cp_ft,:cp_pr,:cp_pt),
     	'FR',lpad(hl.lookup_code,2,' ')||'.'||<