DBA Data[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on HR_LOOKUPS

Line 449: hr_lookups hrl

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