APPS.PER_US_EEO5_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 291: per_all_assignments_f ass,

287: COUNT(DECODE(peo.per_information1,'3',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
288: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
289: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
290: FROM per_all_people_f peo,
291: per_all_assignments_f ass,
292: per_assignment_status_types ast,
293: per_jobs job,
294: hr_lookups hl
295: WHERE peo.person_id = ass.person_id

Line 358: per_all_assignments_f ass,

354: COUNT(DECODE(peo.per_information1,'3',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
355: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
356: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
357: FROM per_all_people_f peo,
358: per_all_assignments_f ass,
359: per_assignment_status_types ast,
360: per_jobs job,
361: hr_lookups hl
362: WHERE peo.person_id = ass.person_id

Line 426: per_all_assignments_f ass,

422: COUNT(DECODE(peo.per_information1,'3',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
423: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
424: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
425: FROM per_all_people_f peo,
426: per_all_assignments_f ass,
427: per_jobs job,
428: hr_lookups hl
429: WHERE peo.person_id = ass.person_id
430: AND peo.current_employee_flag = 'Y'

Line 478: per_all_assignments_f ass,

474: count(decode(pei.pei_information5,'3',decode(peo.sex,'F',1,null),'9',decode(peo.sex,'F',1,null),null)) no_tmraces_hfemale_emps,
475: count(decode(pei.pei_information5,'4',decode(peo.sex,'F',1,null),'5',decode(peo.sex,'F',1,null),null)) no_tmraces_afemale_emps,
476: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
477: FROM per_all_people_f peo,
478: per_all_assignments_f ass,
479: per_assignment_status_types ast,
480: per_jobs job,
481: hr_lookups hl,
482: per_people_extra_info pei

Line 530: per_all_assignments_f ass,

526: count(decode(pei.pei_information5,'3',decode(peo.sex,'F',1,null),'9',decode(peo.sex,'F',1,null),null)) no_tmraces_hfemale_emps,
527: count(decode(pei.pei_information5,'4',decode(peo.sex,'F',1,null),'5',decode(peo.sex,'F',1,null),null)) no_tmraces_afemale_emps,
528: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
529: FROM per_all_people_f peo,
530: per_all_assignments_f ass,
531: per_assignment_status_types ast,
532: per_jobs job,
533: hr_lookups hl,
534: per_people_extra_info pei

Line 597: per_all_assignments_f ass,

593: count(decode(pei.pei_information5,'3',decode(peo.sex,'F',1,null),'9',decode(peo.sex,'F',1,null),null)) no_tmraces_hfemale_emps,
594: count(decode(pei.pei_information5,'4',decode(peo.sex,'F',1,null),'5',decode(peo.sex,'F',1,null),null)) no_tmraces_afemale_emps,
595: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
596: FROM per_all_people_f peo,
597: per_all_assignments_f ass,
598: per_jobs job,
599: hr_lookups hl,
600: per_people_extra_info pei
601: WHERE peo.person_id = ass.person_id

Line 660: FROM per_all_assignments_f ass,

656: CURSOR csr_annexes(p_report_date IN DATE,p_business_group_id IN NUMBER) IS
657: SELECT COUNT(1)
658: FROM (
659: SELECT ass.location_id
660: FROM per_all_assignments_f ass,
661: hr_organization_units_v hou,
662: per_all_people_f peo
663: WHERE ass.organization_id = hou.organization_id
664: AND ass.person_id = peo.person_id