APPS.PQP_ABSENCE_PLAN_PROCESS dependencies on HR_LOOKUPS

Line 443: FROM hr_lookups

439: RETURN NUMBER IS
440:
441: CURSOR csr_gap_absence_type(p_absence_type_id NUMBER) IS
442: SELECT 1
443: FROM hr_lookups
444: WHERE lookup_type = 'PQP_GAP_ABSENCE_TYPES_LIST'
445: AND lookup_code = p_absence_type_id ;
446:
447: l_exists NUMBER ;