DBA Data[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on HR_LOOKUPS

Line 451: hr_lookups hrl

447: per_addresses pad,
448: per_assignment_extra_info paei,
449: per_periods_of_service pps,
450: hr_soft_coding_keyflex hsck,
451: hr_lookups hrl
452: WHERE paaf.person_id = papf.person_id
453: AND TO_DATE('31-03-'|| c_reporting_year, 'DD-MM-YYYY')
454: BETWEEN paaf.effective_start_date and paaf.effective_end_date
455: AND papf.effective_end_date = NVL(pps.actual_termination_date,TO_DATE('31-12-4712','dd-mm-yyyy')) /* Bug No : 3642506*/