ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471ED51A9E05362FB09050512 select JobCode, JobType, SalCode, SalRange,CF_group_lineno,CF_GroupTotTitle, PQH_PQIPED6_XMLP_PKG.line1Formula() line_no ,rownum from (select to_number(hl.lookup_code) JobCode, hl.meaning JobType, hs.lookup_code SalCode, decode(hl.lookup_code, '8' , decode(hs.lookup_code,'01', 'Below $20,000', '02', '20,000-29,999', '03', '30,000-39,999', '04','40,000-49,999','05','50,000 and above'), '9', decode(hs.lookup_code,'01', 'Below $20,000', '02', '20,000-29,999', '03', '30,000-39,999', '04','40,000-49,999','05','50,000 and above'), '10', decode(hs.lookup_code,'01', 'Below $20,000', '02', '20,000-29,999', '03', '30,000-39,999', '04','40,000-49,999','05','50,000 and above'), '11',decode(hs.lookup_code,'01', 'Below $20,000', '02', '20,000-29,999', '03', '30,000-39,999', '04','40,000-49,999','05','50,000 and above'), hs.meaning) SalRange, PQH_PQIPED6_XMLP_PKG.cf_group_linenoformula(to_number ( hl.lookup_code )) CF_group_lineno, PQH_PQIPED6_XMLP_PKG.cf_grouptottitleformula(to_number(hl.lookup_code)) CF_GroupTotTitle --PQH_PQIPED6_XMLP_PKG.line1Formula() line_no from hr_lookups hl, hr_lookups hs where hl.lookup_type = 'US_IPEDS_JOB_CATEGORIES' and hl.lookup_code not in ('1', '2' ,'3','4', '12') and hs.lookup_type = 'PQH_SALARY_RANGE' order by to_number(hl.lookup_code), SalCode ) Y PQH PQIPED6_XML US PQH IPEDS Report - Staff Survey (S1) - Part B(obsoleted) Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Staff Survey (S1) - Part B (XML) (obsoleted) Short Name: PQIPED6_XML DB package: PQH_PQIPED6_XMLP_PKG BI Publisher :cp_fr :cp_ft :cp_lastlineno :cp_pr :cp_pt :cp_reporttottitle :line_num :lp_report_date :p_business_group_id :p_conc_request_id :p_report_date :tmp_var :tmp_var1 :tmp_var2 1 -20 :p_business_group_id Char fnd_profile.value('PER_BUSINESS_GROUP_ID') US Business Group ID Business Group ID 2 10 :p_report_date Date Y US Reporting Date Reporting Date