DBA Data[Home] [Help]

APPS.HR_NI_CHK_PKG dependencies on PER_ALL_PEOPLE_F

Line 554: FROM per_all_people_f pp

550: SELECT 'Y'
551: INTO l_status
552: FROM sys.dual
553: WHERE exists(SELECT '1'
554: FROM per_all_people_f pp
555: WHERE (p_person_id IS NULL
556: OR p_person_id <> pp.person_id)
557: AND p_national_identifier = pp.national_identifier
558: AND pp.business_group_id +0 = p_business_group_id);