APPS.PAY_SE_ARCHIVE_TETA dependencies on HR_LEG_LOOKUPS

Line 460: FROM hr_leg_lookups l

456: ( csr_v_lookup_code VARCHAR2
457: , csr_v_effective_date DATE )
458: IS
459: SELECT l.meaning employment_category
460: FROM hr_leg_lookups l
461: WHERE l.lookup_type = 'EMP_CAT'
462: AND l.enabled_flag = 'Y'
463: AND l.lookup_code = csr_v_lookup_code
464: AND csr_v_effective_date