APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on HR_GENERAL

Line 2801: and sysdate between a1.date_from and nvl(a1.date_to, hr_general.end_of_time)

2797: from per_addresses a2
2798: where a2.primary_flag = 'Y'
2799: and a2.person_id = a1.person_id)
2800: */
2801: and sysdate between a1.date_from and nvl(a1.date_to, hr_general.end_of_time)
2802: and a1.primary_flag = 'Y'
2803: and per.assignment_id = a.assignment_id
2804: and a.action_information_category = 'ADDRESS DETAILS'
2805: and a.action_context_type = 'AAP'