APPS.PER_MX_VALIDATIONS dependencies on PER_ALL_PEOPLE_F

Line 82: FROM per_all_people_f pp

78: SELECT 'Y'
79: INTO l_status
80: FROM sys.dual
81: WHERE exists(SELECT /*+index(pp)*/'1'
82: FROM per_all_people_f pp
83: WHERE (p_person_id IS NULL
84: OR p_person_id <> pp.person_id)
85: AND translate(l_valid, '1-', '1') = translate(pp.per_information2, '1-', '1')
86: AND pp.business_group_id +0 = p_business_group_id);

Line 192: FROM per_all_people_f pp

188: SELECT 'Y'
189: INTO l_status
190: FROM sys.dual
191: WHERE exists(SELECT /*+INDEX(pp)*/'1'
192: FROM per_all_people_f pp
193: WHERE (p_person_id IS NULL
194: OR p_person_id <> pp.person_id)
195: AND translate(l_valid, '1-', '1') = translate(pp.per_information3, '1-', '1')
196: AND pp.business_group_id +0 = p_business_group_id);

Line 294: FROM per_all_people_f pp

290: SELECT 'Y'
291: INTO l_status
292: FROM sys.dual
293: WHERE exists(SELECT '1'
294: FROM per_all_people_f pp
295: WHERE (p_person_id IS NULL
296: OR p_person_id <> pp.person_id)
297: AND p_ms_id = pp.per_information6
298: AND pp.business_group_id = p_business_group_id);

Line 387: FROM per_all_people_f pp

383: SELECT 'Y'
384: INTO l_status
385: FROM sys.dual
386: WHERE exists(SELECT '1'
387: FROM per_all_people_f pp
388: WHERE (p_person_id IS NULL
389: OR p_person_id <> pp.person_id)
390: AND p_fga_id = pp.per_information5
391: AND pp.business_group_id = p_business_group_id);