APPS.PER_US_EEO4A_PKG dependencies on PER_PEOPLE_EXTRA_INFO

Line 120: FROM per_people_extra_info pei

116: pei.pei_information3,
117: pei.pei_information4,
118: pei.pei_information5,
119: pei.pei_information6
120: FROM per_people_extra_info pei
121: WHERE pei.person_id = cp_person_id
122: AND pei.information_type = 'US_EEO4A_ETHNIC_ORIGIN';
123:
124: l_ethnic_origin NUMBER;

Line 1584: FROM per_people_extra_info ppei

1580: AND ass.assignment_status_type_id = past.assignment_status_type_id
1581: AND peo.current_employee_flag = ''Y''
1582: AND ass.assignment_type = ''E''
1583: AND (NOT EXISTS (SELECT ''X''
1584: FROM per_people_extra_info ppei
1585: WHERE ppei.person_id = peo.person_id
1586: AND ppei.information_type = ''US_ETHNIC_ORIGIN''
1587: AND(DECODE(ppei.pei_information1, ''Y'', 1,0)
1588: + DECODE(ppei.pei_information2, ''Y'', 1,0)

Line 1620: FROM per_people_extra_info ppei

1616: AND TO_DATE(''' || l_report_date || ''', ''DD-MM-YYYY'')) ';
1617:
1618: -- added for bug 14034790
1619: l_eeo4a_ethnic := ' AND ( EXISTS (SELECT ''X''
1620: FROM per_people_extra_info ppei
1621: WHERE ppei.person_id = peo.person_id
1622: AND ppei.information_type = ''US_EEO4A_ETHNIC_ORIGIN''
1623: AND(DECODE(ppei.pei_information1, ''Y'', 1,0)
1624: + DECODE(ppei.pei_information2, ''Y'', 1,0)