DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL1_CANCELLED_PKG dependencies on FND_DATE

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

471: hr_all_organization_units hou
472: where hou.business_group_id = cp_bg_id
473: AND hou.organization_id = hoi.organization_id
474: AND hou.date_from <= cp_eff_date
475: AND nvl(hou.date_to,fnd_date.canonical_to_date('4712/12/31 00:00:00'))
476: >= cp_eff_date
477: AND hoi.org_information_context = 'Prov Reporting Est'
478: AND hoi.org_information4 = 'P01'
479: AND exists ( SELECT 1