APPS.PER_US_EEO5_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 305: per_all_assignments_f ass,

301: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
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

Line 386: per_all_assignments_f ass,

382: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
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

Line 468: per_all_assignments_f ass,

464: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
465: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
466: Commented for bug#11736960 ends */
467: FROM per_all_people_f peo,
468: per_all_assignments_f ass,
469: per_jobs job,
470: hr_lookups hl
471: WHERE peo.person_id = ass.person_id
472: AND peo.current_employee_flag = 'Y'

Line 524: per_all_assignments_f ass,

520: count(decode(pei.pei_information5,'3',decode(peo.sex,'F',1,null),'9',decode(peo.sex,'F',1,null),null)) no_tmraces_hfemale_emps,
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

Line 578: per_all_assignments_f ass,

574: count(decode(pei.pei_information5,'3',decode(peo.sex,'F',1,null),'9',decode(peo.sex,'F',1,null),null)) no_tmraces_hfemale_emps,
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

Line 647: per_all_assignments_f ass,

643: count(decode(pei.pei_information5,'3',decode(peo.sex,'F',1,null),'9',decode(peo.sex,'F',1,null),null)) no_tmraces_hfemale_emps,
644: count(decode(pei.pei_information5,'4',decode(peo.sex,'F',1,null),'5',decode(peo.sex,'F',1,null),null)) no_tmraces_afemale_emps,
645: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
646: FROM per_all_people_f peo,
647: per_all_assignments_f ass,
648: per_jobs job,
649: hr_lookups hl,
650: per_people_extra_info pei
651: WHERE peo.person_id = ass.person_id

Line 712: FROM per_all_assignments_f ass,

708: CURSOR csr_annexes(p_report_date IN DATE,p_business_group_id IN NUMBER) IS
709: SELECT COUNT(1)
710: FROM (
711: SELECT ass.location_id
712: FROM per_all_assignments_f ass,
713: hr_organization_units_v hou,
714: per_all_people_f peo
715: WHERE ass.organization_id = hou.organization_id
716: AND ass.person_id = peo.person_id