DBA Data[Home] [Help]

APPS.HR_ES_UTILITY dependencies on PER_PEOPLE_F

Line 363: FROM per_people_f pp

359: SELECT 'Y'
360: INTO l_status
361: FROM sys.dual
362: WHERE exists(SELECT '1'
363: FROM per_people_f pp
364: WHERE (p_person_id IS NULL OR p_person_id <> pp.person_id)
365: AND p_identifier_value = pp.per_information3
366: AND p_identifier_type = pp.per_information2
367: AND pp.business_group_id = p_business_group_id);