DBA Data[Home] [Help]

APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on HR_LOOKUPS

Line 12465: FROM hr_lookups hl,

12461: --END TEMPIK
12462: --
12463: cursor c_abs_reason(cv_lookup_code in varchar2, cv_effective_date in date) is
12464: SELECT hl.lookup_code
12465: FROM hr_lookups hl,
12466: per_abs_attendance_reasons abs
12467: WHERE hl.lookup_type = 'ABSENCE_REASON'
12468: AND hl.lookup_code = abs.name
12469: AND hl.lookup_code = cv_lookup_code