DBA Data[Home] [Help]

APPS.HR_ES_UTILITY dependencies on PER_PEOPLE_F

Line 302: FROM per_people_f pp

298: SELECT 'Y'
299: INTO l_status
300: FROM sys.dual
301: WHERE exists(SELECT '1'
302: FROM per_people_f pp
303: WHERE (p_person_id IS NULL OR p_person_id <> pp.person_id)
304: AND p_identifier_value = pp.per_information3
305: AND p_identifier_type = pp.per_information2
306: AND pp.business_group_id = p_business_group_id);