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 3099: and ppa.effective_date between fnd_date.canonical_to_date(''' ||

3095: 'select distinct paa.assignment_id
3096: from pay_assignment_actions paa,
3097: pay_payroll_actions ppa
3098: where ppa.business_group_id = ''' || ln_business_group_id || '''
3099: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
3100: fnd_date.date_to_canonical(ld_start_date) || ''')
3101: and fnd_date.canonical_to_date(''' ||
3102: fnd_date.date_to_canonical(ld_end_date) || ''')
3103: and ppa.action_type in (''U'',''P'',''B'',''V'')

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

3096: from pay_assignment_actions paa,
3097: pay_payroll_actions ppa
3098: where ppa.business_group_id = ''' || ln_business_group_id || '''
3099: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
3100: fnd_date.date_to_canonical(ld_start_date) || ''')
3101: and fnd_date.canonical_to_date(''' ||
3102: fnd_date.date_to_canonical(ld_end_date) || ''')
3103: and ppa.action_type in (''U'',''P'',''B'',''V'')
3104: and decode(ppa.action_type,

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

3097: pay_payroll_actions ppa
3098: where ppa.business_group_id = ''' || ln_business_group_id || '''
3099: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
3100: fnd_date.date_to_canonical(ld_start_date) || ''')
3101: and fnd_date.canonical_to_date(''' ||
3102: fnd_date.date_to_canonical(ld_end_date) || ''')
3103: and ppa.action_type in (''U'',''P'',''B'',''V'')
3104: and decode(ppa.action_type,
3105: ''B'', nvl(ppa.future_process_mode, ''Y''),

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

3098: where ppa.business_group_id = ''' || ln_business_group_id || '''
3099: and ppa.effective_date between fnd_date.canonical_to_date(''' ||
3100: fnd_date.date_to_canonical(ld_start_date) || ''')
3101: and fnd_date.canonical_to_date(''' ||
3102: fnd_date.date_to_canonical(ld_end_date) || ''')
3103: and ppa.action_type in (''U'',''P'',''B'',''V'')
3104: and decode(ppa.action_type,
3105: ''B'', nvl(ppa.future_process_mode, ''Y''),
3106: ''N'') = ''N''