APPS.PAY_CA_EOY_ARCHIVE dependencies on FND_DATE

Line 3801: fnd_date.canonical_to_date('''||

3797: per_all_assignments_f asg,
3798: pay_payroll_actions ppa1
3799: where ppa1.payroll_action_id = :payroll_action_id
3800: and ppa.effective_date between
3801: fnd_date.canonical_to_date('''||
3802: fnd_date.date_to_canonical(l_year_start)||''') and
3803: fnd_date.canonical_to_date('''||
3804: fnd_date.date_to_canonical(l_year_end)||''')
3805: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')

Line 3802: fnd_date.date_to_canonical(l_year_start)||''') and

3798: pay_payroll_actions ppa1
3799: where ppa1.payroll_action_id = :payroll_action_id
3800: and ppa.effective_date between
3801: fnd_date.canonical_to_date('''||
3802: fnd_date.date_to_canonical(l_year_start)||''') and
3803: fnd_date.canonical_to_date('''||
3804: fnd_date.date_to_canonical(l_year_end)||''')
3805: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
3806: and ppa.action_status = ''C''

Line 3803: fnd_date.canonical_to_date('''||

3799: where ppa1.payroll_action_id = :payroll_action_id
3800: and ppa.effective_date between
3801: fnd_date.canonical_to_date('''||
3802: fnd_date.date_to_canonical(l_year_start)||''') and
3803: fnd_date.canonical_to_date('''||
3804: fnd_date.date_to_canonical(l_year_end)||''')
3805: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
3806: and ppa.action_status = ''C''
3807: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'

Line 3804: fnd_date.date_to_canonical(l_year_end)||''')

3800: and ppa.effective_date between
3801: fnd_date.canonical_to_date('''||
3802: fnd_date.date_to_canonical(l_year_start)||''') and
3803: fnd_date.canonical_to_date('''||
3804: fnd_date.date_to_canonical(l_year_end)||''')
3805: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
3806: and ppa.action_status = ''C''
3807: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
3808: and ppa.payroll_action_id = paa.payroll_action_id