DBA Data[Home] [Help]

APPS.PER_US_EEO5_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 482: per_people_extra_info pei

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
483: WHERE peo.person_id = ass.person_id
484: AND peo.per_information1 = '13'
485: AND peo.person_id = pei.person_id(+)
486: AND pei.information_type = 'PER_US_ADDL_ETHNIC_CAT'

Line 534: per_people_extra_info pei

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
535: WHERE peo.person_id = ass.person_id
536: AND peo.per_information1 = '13'
537: AND peo.person_id = pei.person_id(+)
538: AND pei.information_type = 'PER_US_ADDL_ETHNIC_CAT'

Line 600: per_people_extra_info pei

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
602: AND peo.per_information1 = '13'
603: AND peo.person_id = pei.person_id(+)
604: AND pei.information_type = 'PER_US_ADDL_ETHNIC_CAT'