APPS.PER_US_ADD_LEG_HOOK dependencies on HR_API

Line 68: and nvl(padd.date_to,hr_api.g_eot)

64: and padd.address_id = p_address_id
65: and asg.assignment_type='E'
66: and asg.payroll_id is not null /*bug 10008870 */
67: and p_effective_date between padd.date_from
68: and nvl(padd.date_to,hr_api.g_eot)
69: and p_effective_date between asg.effective_start_date
70: and asg.effective_end_date;
71: BEGIN
72: /* bug: 10008870 */