APPS.HR_NI_CHK_PKG dependencies on PER_ALL_PEOPLE_F

Line 558: FROM per_all_people_f pp

554: SELECT 'Y'
555: INTO l_status
556: FROM sys.dual
557: WHERE exists(SELECT '1'
558: FROM per_all_people_f pp
559: WHERE (p_person_id IS NULL
560: OR p_person_id <> pp.person_id)
561: AND substr(p_national_identifier, 1, 8) = substr(pp.national_identifier, 1, 8)
562: AND pp.business_group_id +0 = p_business_group_id);

Line 568: FROM per_all_people_f pp

564: SELECT 'Y'
565: INTO l_status
566: FROM sys.dual
567: WHERE exists(SELECT '1'
568: FROM per_all_people_f pp
569: WHERE (p_person_id IS NULL
570: OR p_person_id <> pp.person_id)
571: AND p_national_identifier = pp.national_identifier
572: AND pp.business_group_id +0 = p_business_group_id);