APPS.PAY_US_ACTION_ARCH dependencies on FND_DATE

Line 160: fnd_date.date_to_canonical instead

156: populate_federal_tax_balances
157: and update_ytd_withheld
158: 18-Sep-2003 vpandya 115.72 Changed range cursor to fix gscc
159: error on date conversion. Using
160: fnd_date.date_to_canonical instead
161: to_char and canonical_to_date
162: instead of to_date.
163: 10-Sep-2003 ekim 115.71 3119792 Added check for whether the archiver
164: 2880047 is run for a given payroll

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

538: from pay_assignment_actions paa,
539: pay_payroll_actions ppa,
540: per_assignments_f paf
541: where ppa.business_group_id = ''' || ln_business_group_id || '''
542: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
543: fnd_date.date_to_canonical(ld_start_date) || ''')
544: and fnd_date.canonical_to_date(''' ||
545: fnd_date.date_to_canonical(ld_end_date) || ''')
546: and ppa.action_type in (''U'',''P'',''B'',''V'')

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

539: pay_payroll_actions ppa,
540: per_assignments_f paf
541: where ppa.business_group_id = ''' || ln_business_group_id || '''
542: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
543: fnd_date.date_to_canonical(ld_start_date) || ''')
544: and fnd_date.canonical_to_date(''' ||
545: fnd_date.date_to_canonical(ld_end_date) || ''')
546: and ppa.action_type in (''U'',''P'',''B'',''V'')
547: and decode(ppa.action_type,

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

540: per_assignments_f paf
541: where ppa.business_group_id = ''' || ln_business_group_id || '''
542: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
543: fnd_date.date_to_canonical(ld_start_date) || ''')
544: and fnd_date.canonical_to_date(''' ||
545: fnd_date.date_to_canonical(ld_end_date) || ''')
546: and ppa.action_type in (''U'',''P'',''B'',''V'')
547: and decode(ppa.action_type,
548: ''B'', nvl(ppa.future_process_mode, ''Y''),

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

541: where ppa.business_group_id = ''' || ln_business_group_id || '''
542: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
543: fnd_date.date_to_canonical(ld_start_date) || ''')
544: and fnd_date.canonical_to_date(''' ||
545: fnd_date.date_to_canonical(ld_end_date) || ''')
546: and ppa.action_type in (''U'',''P'',''B'',''V'')
547: and decode(ppa.action_type,
548: ''B'', nvl(ppa.future_process_mode, ''Y''),
549: ''N'') = ''N''

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

5291: if gv_act_param_val is not null then
5292: if gv_act_param_val = 'Y'
5293: then
5294: ld_last_xfr_eff_date := NULL;
5295: elsif fnd_date.canonical_to_date(gv_act_param_val) = p_xfr_end_date
5296: then
5297: ld_last_xfr_eff_date := NULL;
5298: end if;
5299: end if;