eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_US_EEO5_PKG dependencies on PER_US_HR_UTILITY_PKG

Line 280: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,

276: 'FR', 'A. FULL-TIME STAFF') employment_category,
277: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
278: 'FR',LPAD(hl.lookup_code,2,' ')||'.'||hl.meaning) job_category_name,
279: -- Added for bug#11736960
280: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
281: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
282: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
283: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
284: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,

Line 281: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,

277: DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,p_fr,p_ft,p_pr,p_pt),
278: 'FR',LPAD(hl.lookup_code,2,' ')||'.'||hl.meaning) job_category_name,
279: -- Added for bug#11736960
280: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
281: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
282: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
283: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
284: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
285: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,

Line 282: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,

278: 'FR',LPAD(hl.lookup_code,2,' ')||'.'||hl.meaning) job_category_name,
279: -- Added for bug#11736960
280: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
281: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
282: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
283: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
284: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
285: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
286: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,

Line 283: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,

279: -- Added for bug#11736960
280: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
281: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
282: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
283: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
284: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
285: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
286: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
287: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,

Line 284: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,

280: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
281: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
282: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
283: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
284: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
285: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
286: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
287: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
288: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,

Line 285: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,

281: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
282: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
283: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
284: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
285: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
286: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
287: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
288: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
289: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,

Line 286: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,

282: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
283: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
284: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
285: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
286: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
287: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
288: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
289: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
290: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps

Line 287: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,

283: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
284: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
285: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
286: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
287: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
288: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
289: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
290: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
291: /* Commented for bug#11736960 starts

Line 288: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,

284: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
285: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
286: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
287: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
288: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
289: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
290: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
291: /* Commented for bug#11736960 starts
292: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,

Line 289: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,

285: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
286: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
287: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
288: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
289: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
290: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
291: /* Commented for bug#11736960 starts
292: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,
293: COUNT(DECODE(peo.per_information1,'1',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,

Line 290: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps

286: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
287: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
288: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
289: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
290: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
291: /* Commented for bug#11736960 starts
292: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,
293: COUNT(DECODE(peo.per_information1,'1',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
294: COUNT(DECODE(peo.per_information1,'2',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,

Line 361: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,

357: '11','20.PROF. INSTR.',
358: '12','20.PROF. INSTR.',
359: '21.ALL OTHER')) job_category_name,
360: -- Added for bug#11736960
361: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
362: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
363: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
364: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
365: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,

Line 362: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,

358: '12','20.PROF. INSTR.',
359: '21.ALL OTHER')) job_category_name,
360: -- Added for bug#11736960
361: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
362: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
363: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
364: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
365: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
366: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,

Line 363: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,

359: '21.ALL OTHER')) job_category_name,
360: -- Added for bug#11736960
361: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
362: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
363: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
364: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
365: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
366: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
367: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,

Line 364: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,

360: -- Added for bug#11736960
361: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
362: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
363: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
364: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
365: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
366: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
367: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
368: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,

Line 365: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,

361: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
362: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
363: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
364: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
365: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
366: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
367: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
368: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
369: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,

Line 366: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,

362: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
363: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
364: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
365: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
366: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
367: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
368: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
369: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
370: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,

Line 367: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,

363: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
364: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
365: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
366: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
367: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
368: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
369: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
370: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
371: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps

Line 368: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,

364: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
365: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
366: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
367: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
368: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
369: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
370: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
371: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
372: /* Commented for bug#11736960 starts

Line 369: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,

365: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
366: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
367: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
368: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
369: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
370: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
371: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
372: /* Commented for bug#11736960 starts
373: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,

Line 370: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,

366: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
367: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
368: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
369: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
370: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
371: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
372: /* Commented for bug#11736960 starts
373: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,
374: COUNT(DECODE(peo.per_information1,'1',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,

Line 371: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps

367: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
368: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
369: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
370: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
371: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
372: /* Commented for bug#11736960 starts
373: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,
374: COUNT(DECODE(peo.per_information1,'1',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
375: COUNT(DECODE(peo.per_information1,'2',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,

Line 443: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,

439: '13','27.NONPROF.', '14','27.NONPROF.',
440: '15','27.NONPROF.', '16','27.NONPROF.',
441: '17','27.NONPROF.', '18','27.NONPROF.') job_category_name,
442: -- Added for bug#11736960
443: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
444: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
445: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
446: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
447: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,

Line 444: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,

440: '15','27.NONPROF.', '16','27.NONPROF.',
441: '17','27.NONPROF.', '18','27.NONPROF.') job_category_name,
442: -- Added for bug#11736960
443: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
444: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
445: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
446: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
447: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
448: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,

Line 445: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,

441: '17','27.NONPROF.', '18','27.NONPROF.') job_category_name,
442: -- Added for bug#11736960
443: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
444: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
445: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
446: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
447: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
448: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
449: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,

Line 446: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,

442: -- Added for bug#11736960
443: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
444: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
445: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
446: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
447: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
448: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
449: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
450: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,

Line 447: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,

443: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,1,2,1,3,1,4,1,5,1,6,1,NULL)) cons_total_category_emps,
444: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
445: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
446: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
447: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
448: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
449: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
450: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
451: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,

Line 448: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,

444: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
445: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
446: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
447: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
448: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
449: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
450: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
451: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
452: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,

Line 449: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,

445: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,
446: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
447: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
448: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
449: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
450: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
451: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
452: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
453: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps

Line 450: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,

446: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_hmale_emps,
447: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
448: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
449: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
450: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
451: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
452: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
453: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
454: /* Commented for bug#11736960 starts

Line 451: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,

447: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'M',1,NULL),5,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_amale_emps,
448: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
449: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
450: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
451: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
452: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
453: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
454: /* Commented for bug#11736960 starts
455: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,

Line 452: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,

448: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_imale_emps,
449: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
450: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
451: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
452: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
453: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
454: /* Commented for bug#11736960 starts
455: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,
456: COUNT(DECODE(peo.per_information1,'1',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,

Line 453: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps

449: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),1,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_wfemale_emps,
450: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),2,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
451: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),3,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
452: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),4,DECODE(peo.sex,'F',1,NULL),5,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
453: COUNT(DECODE(per_us_hr_utility_pkg.derive_single_race(peo.person_id),6,DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
454: /* Commented for bug#11736960 starts
455: COUNT(DECODE(peo.per_information1,'1',1,'2',1,'3',1,'4',1,'5',1,'6',1,'7',1,NULL)) cons_total_category_emps,
456: COUNT(DECODE(peo.per_information1,'1',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_wmale_emps,
457: COUNT(DECODE(peo.per_information1,'2',DECODE(peo.sex,'M',1,NULL),NULL)) no_cons_bmale_emps,