APPS.PAY_CA_EOY_RL2_ARCHIVE dependencies on FND_DATE

Line 3160: to_char(fnd_date.canonical_to_date(lv_eit_year), 'YYYY')) and

3156:
3157: exit when c_get_preprinted_form_no%NOTFOUND;
3158:
3159: if ((lv_fapp_effective_date =
3160: to_char(fnd_date.canonical_to_date(lv_eit_year), 'YYYY')) and
3161: (ln_fapp_pre_org_id = to_number(lv_eit_pre_org_id))) then
3162:
3163: pay_ca_eoy_rl2_archive.ltr_ppa_arch_ee_data2(ln_index).act_info1
3164: := lv_eit_form_no;

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

3240: per_all_assignments_f asg,
3241: pay_payroll_actions ppa1
3242: where ppa1.payroll_action_id = :payroll_action_id
3243: and ppa.effective_date between
3244: fnd_date.canonical_to_date('''||
3245: fnd_date.date_to_canonical(l_year_start)||''') and
3246: fnd_date.canonical_to_date('''||
3247: fnd_date.date_to_canonical(l_year_end)||''')
3248: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')

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

3241: pay_payroll_actions ppa1
3242: where ppa1.payroll_action_id = :payroll_action_id
3243: and ppa.effective_date between
3244: fnd_date.canonical_to_date('''||
3245: fnd_date.date_to_canonical(l_year_start)||''') and
3246: fnd_date.canonical_to_date('''||
3247: fnd_date.date_to_canonical(l_year_end)||''')
3248: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
3249: and ppa.action_status = ''C''

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

3242: where ppa1.payroll_action_id = :payroll_action_id
3243: and ppa.effective_date between
3244: fnd_date.canonical_to_date('''||
3245: fnd_date.date_to_canonical(l_year_start)||''') and
3246: fnd_date.canonical_to_date('''||
3247: fnd_date.date_to_canonical(l_year_end)||''')
3248: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
3249: and ppa.action_status = ''C''
3250: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'

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

3243: and ppa.effective_date between
3244: fnd_date.canonical_to_date('''||
3245: fnd_date.date_to_canonical(l_year_start)||''') and
3246: fnd_date.canonical_to_date('''||
3247: fnd_date.date_to_canonical(l_year_end)||''')
3248: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
3249: and ppa.action_status = ''C''
3250: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
3251: and ppa.payroll_action_id = paa.payroll_action_id