DBA Data[Home] [Help]

APPS.PAY_GB_P11D_ARCHIVE_SS dependencies on HR_GENERAL

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

2731: from per_addresses a2
2732: where a2.primary_flag = 'Y'
2733: and a2.person_id = a1.person_id)
2734: */
2735: and sysdate between a1.date_from and nvl(a1.date_to, hr_general.end_of_time)
2736: and a1.primary_flag = 'Y'
2737: and per.assignment_id = a.assignment_id
2738: and a.action_information_category = 'ADDRESS DETAILS'
2739: and a.action_context_type = 'AAP'