[Home] [Help]
448: SELECT 'Y'
449: INTO l_status
450: FROM sys.dual
451: WHERE exists(SELECT '1'
452: FROM per_all_people_f pp
453: WHERE (p_person_id IS NULL
454: OR p_person_id <> pp.person_id)
455: AND p_identifier = pp.per_information2
456: AND pp.business_group_id = p_business_group_id);