DBA Data[Home] [Help]

APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on FND_DATE

Line 490: fnd_date.canonical_to_date('4712/12/31 00:00:00')) >= cp_eff_date

486: where hou.business_group_id = cp_bg_id
487: AND hou.organization_id = hoi.organization_id
488: AND hou.date_from <= cp_eff_date
489: AND nvl(hou.date_to,
490: fnd_date.canonical_to_date('4712/12/31 00:00:00')) >= cp_eff_date
491: AND hoi.org_information_context = 'Prov Reporting Est'
492: AND hoi.org_information4 = 'P02'
493: AND exists ( SELECT 1
494: FROM pay_payroll_actions ppa ,