APPS.PER_US_EEO5_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 306: per_assignment_status_types ast,

302: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
303: Commented for bug#11736960 ends */
304: FROM per_all_people_f peo,
305: per_all_assignments_f ass,
306: per_assignment_status_types ast,
307: per_jobs job,
308: hr_lookups hl
309: WHERE peo.person_id = ass.person_id
310: AND peo.current_employee_flag = 'Y'

Line 387: per_assignment_status_types ast,

383: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
384: Commented for bug#11736960 ends */
385: FROM per_all_people_f peo,
386: per_all_assignments_f ass,
387: per_assignment_status_types ast,
388: per_jobs job,
389: hr_lookups hl
390: WHERE peo.person_id = ass.person_id
391: AND peo.current_employee_flag = 'Y'

Line 525: per_assignment_status_types ast,

521: count(decode(pei.pei_information5,'4',decode(peo.sex,'F',1,null),'5',decode(peo.sex,'F',1,null),null)) no_tmraces_afemale_emps,
522: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
523: FROM per_all_people_f peo,
524: per_all_assignments_f ass,
525: per_assignment_status_types ast,
526: per_jobs job,
527: hr_lookups hl,
528: per_people_extra_info pei
529: WHERE peo.person_id = ass.person_id

Line 579: per_assignment_status_types ast,

575: count(decode(pei.pei_information5,'4',decode(peo.sex,'F',1,null),'5',decode(peo.sex,'F',1,null),null)) no_tmraces_afemale_emps,
576: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
577: FROM per_all_people_f peo,
578: per_all_assignments_f ass,
579: per_assignment_status_types ast,
580: per_jobs job,
581: hr_lookups hl,
582: per_people_extra_info pei
583: WHERE peo.person_id = ass.person_id