ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D471F051A9E05362FB09050512 SELECT distinct value1 jCode, value2 NRMen, value3 NRWmen, value4 BnHMen, value5 BnHWmen, value6 Am_AlMen, value7 Am_AlWmen, value8 AMen, value9 AWmen, value10 HMen, value11 HWmen, value12 WnHMen, value13 WnHWmen, value14 URMen, value15 URWmen, value16 TotMen, value17 TotWmen, value18 NHOPMen, value19 NHOPWmen, value20 TmrMen, value21 TmrWmen FROM pay_us_rpt_totals WHERE session_id = userenv('sessionid') AND attribute1 = 'IPED9' and value1=:jobCode Y PQH PQIPED9_XML US PQH IPEDS Report - Staff Survey (S1) - Part G(obsoleted) Imported from BI Publisher Application: Public Sector HR Source: IPEDS Report - Staff Survey (S1) - Part G (XML) (obsoleted) Short Name: PQIPED9_XML DB package: PQH_PQIPED9_XMLP_PKG BI Publisher :cp_fr :cp_ft :cp_hire_date :cp_pr :cp_pt :jobcode :last_lineno :line_num :lp_hire_date :p_business_group_id :p_conc_request_id :p_report_date :p_report_date_t :totreporttitle 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