APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on FND_DATE

Line 323: AND nvl(hou.date_to,fnd_date.canonical_to_date('4712/12/31 00:00:00'))

319: hr_all_organization_units hou
320: where hou.business_group_id = cp_bg_id
321: AND hou.organization_id = hoi.organization_id
322: AND hou.date_from <= cp_eff_date
323: AND nvl(hou.date_to,fnd_date.canonical_to_date('4712/12/31 00:00:00'))
324: >= cp_eff_date
325: AND hoi.org_information_context = 'Canada Employer Identification'
326: AND hoi.org_information5 in ('T4A/RL1','T4A/RL2')
327: AND exists ( SELECT 1