APPS.HR_ES_UTILITY dependencies on PER_SHARED_TYPES

Line 627: FROM per_shared_types pp

623: SELECT 'Y'
624: INTO l_status
625: FROM sys.dual
626: WHERE exists(SELECT '1'
627: FROM per_shared_types pp
628: WHERE lookup_type = 'LEAV_REAS'
629: AND system_type_cd = p_leaving_reason
630: AND nvl(business_group_id,p_business_group_id)
631: = p_business_group_id