APPS.PER_EEO_MAG_REPORT dependencies on PER_PEOPLE_EXTRA_INFO

Line 1955: FROM per_people_extra_info pei

1951: WHERE peo.person_id = ass.person_id
1952: --AND peo.per_information1 is not NULL commented for fix for #12616269
1953: -- Added for fix for #12616269
1954: AND EXISTS (SELECT 'X'
1955: FROM per_people_extra_info pei
1956: WHERE pei.person_id = peo.person_id
1957: AND pei.information_type = 'US_ETHNIC_ORIGIN'
1958: AND (pei.pei_information1 = 'Y'
1959: OR pei.pei_information2 = 'Y'

Line 2054: FROM per_people_extra_info pei

2050: WHERE peo.person_id = ass.person_id
2051: --AND peo.per_information1 is not NULL commented for fix for #12616269
2052: -- Added for fix for #12616269
2053: AND EXISTS (SELECT 'X'
2054: FROM per_people_extra_info pei
2055: WHERE pei.person_id = peo.person_id
2056: AND pei.information_type = 'US_ETHNIC_ORIGIN'
2057: AND (pei.pei_information1 = 'Y'
2058: OR pei.pei_information2 = 'Y'

Line 2158: FROM per_people_extra_info pei

2154: WHERE peo.person_id = ass.person_id
2155: --AND peo.per_information1 is not NULL commented for fix for #12616269
2156: -- Added for fix for #12616269
2157: AND EXISTS (SELECT 'X'
2158: FROM per_people_extra_info pei
2159: WHERE pei.person_id = peo.person_id
2160: AND pei.information_type = 'US_ETHNIC_ORIGIN'
2161: AND (pei.pei_information1 = 'Y'
2162: OR pei.pei_information2 = 'Y'

Line 2303: FROM per_people_extra_info pei

2299: AND pgn_loc.parent_hierarchy_node_id = pgn_est.hierarchy_node_id
2300: AND pgn_loc.business_group_id = p_business_group_id)
2301: -- Added for fix for #12616269 start
2302: AND EXISTS (SELECT 'X'
2303: FROM per_people_extra_info pei
2304: WHERE pei.person_id = peo.person_id
2305: AND pei.information_type = 'US_ETHNIC_ORIGIN'
2306: AND (pei.pei_information1 = 'Y'
2307: OR pei.pei_information2 = 'Y'