APPS.PAY_CA_T4AEOY_ARCHIVE dependencies on FND_DATE

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

5494: per_all_assignments_f asg,
5495: pay_payroll_actions ppa1
5496: where ppa1.payroll_action_id = :payroll_action_id
5497: and ppa.effective_date between
5498: fnd_date.canonical_to_date('''||
5499: fnd_date.date_to_canonical(l_year_start)||''') and
5500: fnd_date.canonical_to_date('''||
5501: fnd_date.date_to_canonical(l_year_end)||''')
5502: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')

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

5495: pay_payroll_actions ppa1
5496: where ppa1.payroll_action_id = :payroll_action_id
5497: and ppa.effective_date between
5498: fnd_date.canonical_to_date('''||
5499: fnd_date.date_to_canonical(l_year_start)||''') and
5500: fnd_date.canonical_to_date('''||
5501: fnd_date.date_to_canonical(l_year_end)||''')
5502: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
5503: and ppa.action_status = ''C''

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

5496: where ppa1.payroll_action_id = :payroll_action_id
5497: and ppa.effective_date between
5498: fnd_date.canonical_to_date('''||
5499: fnd_date.date_to_canonical(l_year_start)||''') and
5500: fnd_date.canonical_to_date('''||
5501: fnd_date.date_to_canonical(l_year_end)||''')
5502: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
5503: and ppa.action_status = ''C''
5504: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'

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

5497: and ppa.effective_date between
5498: fnd_date.canonical_to_date('''||
5499: fnd_date.date_to_canonical(l_year_start)||''') and
5500: fnd_date.canonical_to_date('''||
5501: fnd_date.date_to_canonical(l_year_end)||''')
5502: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
5503: and ppa.action_status = ''C''
5504: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
5505: and ppa.payroll_action_id = paa.payroll_action_id