APPS.PAY_US_ACTION_ARCH dependencies on FND_DATE

Line 244: fnd_date.date_to_canonical instead

240: populate_federal_tax_balances
241: and update_ytd_withheld
242: 18-Sep-2003 vpandya 115.72 Changed range cursor to fix gscc
243: error on date conversion. Using
244: fnd_date.date_to_canonical instead
245: to_char and canonical_to_date
246: instead of to_date.
247: 10-Sep-2003 ekim 115.71 3119792 Added check for whether the archiver
248: 2880047 is run for a given payroll

Line 641: and ppa.effective_date between fnd_date.canonical_to_date(''' ||

637: from pay_assignment_actions paa,
638: pay_payroll_actions ppa,
639: per_assignments_f paf
640: where ppa.business_group_id = ''' || ln_business_group_id || '''
641: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
642: fnd_date.date_to_canonical(ld_start_date) || ''')
643: and fnd_date.canonical_to_date(''' ||
644: fnd_date.date_to_canonical(ld_end_date) || ''')
645: and ppa.action_type in (''U'',''P'',''B'',''V'')

Line 642: fnd_date.date_to_canonical(ld_start_date) || ''')

638: pay_payroll_actions ppa,
639: per_assignments_f paf
640: where ppa.business_group_id = ''' || ln_business_group_id || '''
641: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
642: fnd_date.date_to_canonical(ld_start_date) || ''')
643: and fnd_date.canonical_to_date(''' ||
644: fnd_date.date_to_canonical(ld_end_date) || ''')
645: and ppa.action_type in (''U'',''P'',''B'',''V'')
646: and decode(ppa.action_type,

Line 643: and fnd_date.canonical_to_date(''' ||

639: per_assignments_f paf
640: where ppa.business_group_id = ''' || ln_business_group_id || '''
641: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
642: fnd_date.date_to_canonical(ld_start_date) || ''')
643: and fnd_date.canonical_to_date(''' ||
644: fnd_date.date_to_canonical(ld_end_date) || ''')
645: and ppa.action_type in (''U'',''P'',''B'',''V'')
646: and decode(ppa.action_type,
647: ''B'', nvl(ppa.future_process_mode, ''Y''),

Line 644: fnd_date.date_to_canonical(ld_end_date) || ''')

640: where ppa.business_group_id = ''' || ln_business_group_id || '''
641: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
642: fnd_date.date_to_canonical(ld_start_date) || ''')
643: and fnd_date.canonical_to_date(''' ||
644: fnd_date.date_to_canonical(ld_end_date) || ''')
645: and ppa.action_type in (''U'',''P'',''B'',''V'')
646: and decode(ppa.action_type,
647: ''B'', nvl(ppa.future_process_mode, ''Y''),
648: ''N'') = ''N''

Line 7096: := fnd_date.date_to_canonical(ln_earned_date);

7092: := ln_emp_payment_method_id;
7093: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
7094: := ln_payee_id;
7095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
7096: := fnd_date.date_to_canonical(ln_earned_date);
7097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
7098: := fnd_date.date_to_canonical(ln_payment_date);
7099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
7100: := ln_payee_name ;

Line 7098: := fnd_date.date_to_canonical(ln_payment_date);

7094: := ln_payee_id;
7095: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
7096: := fnd_date.date_to_canonical(ln_earned_date);
7097: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
7098: := fnd_date.date_to_canonical(ln_payment_date);
7099: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
7100: := ln_payee_name ;
7101: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
7102: := ln_address_line1;

Line 7308: elsif fnd_date.canonical_to_date(gv_act_param_val) = p_xfr_end_date

7304: if gv_act_param_val is not null then
7305: if gv_act_param_val = 'Y'
7306: then
7307: ld_last_xfr_eff_date := NULL;
7308: elsif fnd_date.canonical_to_date(gv_act_param_val) = p_xfr_end_date
7309: then
7310: ld_last_xfr_eff_date := NULL;
7311: end if;
7312: end if;