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_EOY_RL2_ARCHIVE dependencies on FND_DATE

Line 1960: and fnd_date.string_to_date('31/12/'||cp_run_year,'DD/MM/YYYY')

1956: from pay_user_tables put,
1957: pay_user_rows_f pur
1958: where pur.USER_TABLE_ID=put.USER_TABLE_ID
1959: and put.USER_TABLE_NAME = 'RL2 PDF Sequence Range'
1960: and fnd_date.string_to_date('31/12/'||cp_run_year,'DD/MM/YYYY')
1961: between pur.EFFECTIVE_START_DATE and pur.EFFECTIVE_END_DATE;
1962:
1963: l_final_seq_num varchar2(240); -- Bug 14701748 - Increased size
1964: l_start_seq_num varchar2(25);

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

3969:
3970: exit when c_get_preprinted_form_no%NOTFOUND;
3971:
3972: if ((lv_fapp_effective_date =
3973: to_char(fnd_date.canonical_to_date(lv_eit_year), 'YYYY')) and
3974: (ln_fapp_pre_org_id = to_number(lv_eit_pre_org_id))) then
3975:
3976: if l_k = 0 then
3977: l_k := 1;

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

4087: per_all_assignments_f asg,
4088: pay_payroll_actions ppa1
4089: where ppa1.payroll_action_id = :payroll_action_id
4090: and ppa.effective_date between
4091: fnd_date.canonical_to_date('''||
4092: fnd_date.date_to_canonical(l_year_start)||''') and
4093: fnd_date.canonical_to_date('''||
4094: fnd_date.date_to_canonical(l_year_end)||''')
4095: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')

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

4088: pay_payroll_actions ppa1
4089: where ppa1.payroll_action_id = :payroll_action_id
4090: and ppa.effective_date between
4091: fnd_date.canonical_to_date('''||
4092: fnd_date.date_to_canonical(l_year_start)||''') and
4093: fnd_date.canonical_to_date('''||
4094: fnd_date.date_to_canonical(l_year_end)||''')
4095: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4096: and ppa.action_status = ''C''

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

4089: where ppa1.payroll_action_id = :payroll_action_id
4090: and ppa.effective_date between
4091: fnd_date.canonical_to_date('''||
4092: fnd_date.date_to_canonical(l_year_start)||''') and
4093: fnd_date.canonical_to_date('''||
4094: fnd_date.date_to_canonical(l_year_end)||''')
4095: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4096: and ppa.action_status = ''C''
4097: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'

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

4090: and ppa.effective_date between
4091: fnd_date.canonical_to_date('''||
4092: fnd_date.date_to_canonical(l_year_start)||''') and
4093: fnd_date.canonical_to_date('''||
4094: fnd_date.date_to_canonical(l_year_end)||''')
4095: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
4096: and ppa.action_status = ''C''
4097: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
4098: and ppa.payroll_action_id = paa.payroll_action_id