eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_PAYROLL_ARCH dependencies on FND_DATE

Line 150: fnd_date.date_to_canonical instead

146: get_last_xfr_info as per teminated
147: asg changes done by ekim.
148: 18-Sep-2003 vpandya 115.25 Changed range cursor to fix gscc
149: error on date conversion. Using
150: fnd_date.date_to_canonical instead
151: to_char and canonical_to_date
152: instead of to_date.
153: 19-Jan-2004 vpandya 115.26 3356401 The SQL ID: 6194306 is for the
154: cursor c_prev_run_information, which

Line 191: 06-Mar-2012 abellur 115.39 13814029 Added fnd_date.date_to_canonical

187: per_people_f.
188: 20-Feb-2012 abellur 115.38 13029997 Added get_3rdparty_cheque to
189: support/archive third party
190: cheque information.
191: 06-Mar-2012 abellur 115.39 13814029 Added fnd_date.date_to_canonical
192: to earned date and payment date
193: for third party cheques.
194: 16-May-2012 sbachu 115.41 9600575 Changed cursor c_payment_info so
195: that context_id's are created under

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

1074: := ln_emp_payment_method_id;
1075: pay_ac_action_arch.lrr_act_tab(ln_index).act_info8
1076: := ln_payee_id;
1077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1078: := fnd_date.date_to_canonical(ln_earned_date);
1079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1080: := fnd_date.date_to_canonical(ln_payment_date);
1081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1082: := ln_payee_name ;

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

1076: := ln_payee_id;
1077: pay_ac_action_arch.lrr_act_tab(ln_index).act_info9
1078: := fnd_date.date_to_canonical(ln_earned_date);
1079: pay_ac_action_arch.lrr_act_tab(ln_index).act_info10
1080: := fnd_date.date_to_canonical(ln_payment_date);
1081: pay_ac_action_arch.lrr_act_tab(ln_index).act_info11
1082: := ln_payee_name ;
1083: pay_ac_action_arch.lrr_act_tab(ln_index).act_info12
1084: := ln_address_line1;

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

3606: 'select distinct paa.assignment_id
3607: from pay_assignment_actions paa,
3608: pay_payroll_actions ppa
3609: where ppa.business_group_id = ''' || ln_business_group_id || '''
3610: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
3611: fnd_date.date_to_canonical(ld_start_date) || ''')
3612: and fnd_date.canonical_to_date(''' ||
3613: fnd_date.date_to_canonical(ld_end_date) || ''')
3614: and ppa.action_type in (''U'',''P'',''B'',''V'')

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

3607: from pay_assignment_actions paa,
3608: pay_payroll_actions ppa
3609: where ppa.business_group_id = ''' || ln_business_group_id || '''
3610: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
3611: fnd_date.date_to_canonical(ld_start_date) || ''')
3612: and fnd_date.canonical_to_date(''' ||
3613: fnd_date.date_to_canonical(ld_end_date) || ''')
3614: and ppa.action_type in (''U'',''P'',''B'',''V'')
3615: and decode(ppa.action_type,

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

3608: pay_payroll_actions ppa
3609: where ppa.business_group_id = ''' || ln_business_group_id || '''
3610: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
3611: fnd_date.date_to_canonical(ld_start_date) || ''')
3612: and fnd_date.canonical_to_date(''' ||
3613: fnd_date.date_to_canonical(ld_end_date) || ''')
3614: and ppa.action_type in (''U'',''P'',''B'',''V'')
3615: and decode(ppa.action_type,
3616: ''B'', nvl(ppa.future_process_mode, ''Y''),

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

3609: where ppa.business_group_id = ''' || ln_business_group_id || '''
3610: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
3611: fnd_date.date_to_canonical(ld_start_date) || ''')
3612: and fnd_date.canonical_to_date(''' ||
3613: fnd_date.date_to_canonical(ld_end_date) || ''')
3614: and ppa.action_type in (''U'',''P'',''B'',''V'')
3615: and decode(ppa.action_type,
3616: ''B'', nvl(ppa.future_process_mode, ''Y''),
3617: ''N'') = ''N''