SELECT decode (hl.lookup_code
,21
,hr_general.decode_lookup('PER_US_IPEDS_RPT_LBL','PST')
,27
,hr_general.decode_lookup('PER_US_IPEDS_RPT_LBL','LCA')
,hl.meaning) Ipeds_Category
,value1 NRMen
,value2 NRWmen
,value3 BnHMen
,value4 BnHWmen
,value5 Am_AlMen
,value6 Am_AlWmen
,value7 AMen
,value8 AWmen
,value9 NH_OPMen
,value10 NH_OPWmen
,value11 HMen
,value12 HWmen
,value13 WnHMen
,value14 WnHWmen
,value15 URMen
,value16 URWMen
,value17 TmrMen
,value18 TmrWmen
,value19 Totmen
,value20 TotWmen
FROM pay_us_rpt_totals prt
,hr_lookups hl
WHERE prt.tax_unit_id(+) = USERENV('sessionid')
AND prt.attribute1(+) = 'NDGIPED'
AND hl.lookup_type = 'US_IPEDS_JOB_CATEGORIES'
AND prt.attribute2(+) = hl.lookup_code
AND hl.enabled_flag = 'Y'
AND hl.lookup_code NOT IN ('12','22','23','24','25','26','28','29')
ORDER BY hl.lookup_code |