APPS.HR_ES_UTILITY dependencies on PER_SHARED_TYPES

Line 707: FROM per_shared_types pp

703: SELECT 'Y'
704: INTO l_status
705: FROM sys.dual
706: WHERE exists(SELECT '1'
707: FROM per_shared_types pp
708: WHERE lookup_type = 'LEAV_REAS'
709: AND system_type_cd = p_leaving_reason
710: AND nvl(business_group_id,p_business_group_id)
711: = p_business_group_id