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

Line 146: fnd_date.date_to_canonical_to_date

142: Also the balance 'RL1 Non Taxable Earnings'
143: is deducted from Gross Earnings.
144: 18-Sep-2003 vpandya 115.50 Archiving dates in canonical format
145: (YYYY/MM/DD HH:MI:SS) using
146: fnd_date.date_to_canonical_to_date
147: instead of using to_char with default
148: format to fix gscc date conversion error.
149: 21-OCT-2003 ssouresr 115.51 Added RL1 Amendment Archiving logic
150: in eoy_archive_data procedure. Also

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

2217: from pay_user_tables put,
2218: pay_user_rows_f pur
2219: where pur.USER_TABLE_ID=put.USER_TABLE_ID
2220: and put.USER_TABLE_NAME = 'RL1 PDF Sequence Range'
2221: and fnd_date.string_to_date('31/12/'||cp_run_year,'DD/MM/YYYY')
2222: between pur.EFFECTIVE_START_DATE and pur.EFFECTIVE_END_DATE;
2223:
2224: /*cursor c_get_act_info(aaid number) is
2225: select ACTION_INFORMATION_ID, OBJECT_VERSION_NUMBER

Line 2299: ,p_effective_date => fnd_date.string_to_date('31/12/'||p_reporting_year,'DD/MM/YYYY')

2295: hr_utility.trace('In pay_ca_eoy_rl1_archive.gen_rl1_pdf_seq 50');
2296:
2297: /* Commented for bug 8732218
2298: ff_archive_api.update_archive_item( p_archive_item_id => l_archive_item_id
2299: ,p_effective_date => fnd_date.string_to_date('31/12/'||p_reporting_year,'DD/MM/YYYY')
2300: --,p_validate in boolean default false
2301: ,p_archive_value => l_final_seq_num
2302: ,p_object_version_number => l_obj_ver
2303: ,p_some_warning => l_warning ); */

Line 4831: fnd_date.date_to_canonical(l_date_of_birth);

4827: hr_utility.trace('Before counter 3');
4828: l_counter := l_counter + 1;
4829: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_DATE_OF_BIRTH';
4830: l_user_entity_value_tab(l_counter):=
4831: fnd_date.date_to_canonical(l_date_of_birth);
4832:
4833: hr_utility.trace('Before counter 3');
4834: l_counter := l_counter + 1;
4835: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_HIRE_DATE';

Line 4837: fnd_date.date_to_canonical(l_hire_date);

4833: hr_utility.trace('Before counter 3');
4834: l_counter := l_counter + 1;
4835: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_HIRE_DATE';
4836: l_user_entity_value_tab(l_counter):=
4837: fnd_date.date_to_canonical(l_hire_date);
4838:
4839: hr_utility.trace('Before counter 3');
4840: l_counter := l_counter + 1;
4841: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_TERMINATION_DATE';

Line 4843: fnd_date.date_to_canonical(l_termination_date);

4839: hr_utility.trace('Before counter 3');
4840: l_counter := l_counter + 1;
4841: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_TERMINATION_DATE';
4842: l_user_entity_value_tab(l_counter):=
4843: fnd_date.date_to_canonical(l_termination_date);
4844:
4845: hr_utility.trace('Before counter 3');
4846: l_counter := l_counter + 1;
4847: l_user_entity_name_tab(l_counter) := 'CAEOY_EMPLOYEE_NUMBER';

Line 4978: if ((lv_fapp_effective_date =to_char(fnd_date.canonical_to_date(lv_eit_year), 'YYYY')) and

4974: lv_eit_form_no;
4975:
4976: exit when c_get_preprinted_form_no%NOTFOUND;
4977:
4978: if ((lv_fapp_effective_date =to_char(fnd_date.canonical_to_date(lv_eit_year), 'YYYY')) and
4979: (ln_fapp_pre_org_id = to_number(lv_eit_pre_org_id))) then
4980: if l_k = 0 then
4981: l_k := 1;
4982: lv_pre_pr_form_no := lv_eit_form_no;

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

5123: per_all_assignments_f asg,
5124: pay_payroll_actions ppa1
5125: where ppa1.payroll_action_id = :payroll_action_id
5126: and ppa.effective_date between
5127: fnd_date.canonical_to_date('''||
5128: fnd_date.date_to_canonical(l_year_start)||''') and
5129: fnd_date.canonical_to_date('''||
5130: fnd_date.date_to_canonical(l_year_end)||''')
5131: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')

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

5124: pay_payroll_actions ppa1
5125: where ppa1.payroll_action_id = :payroll_action_id
5126: and ppa.effective_date between
5127: fnd_date.canonical_to_date('''||
5128: fnd_date.date_to_canonical(l_year_start)||''') and
5129: fnd_date.canonical_to_date('''||
5130: fnd_date.date_to_canonical(l_year_end)||''')
5131: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
5132: and ppa.action_status = ''C''

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

5125: where ppa1.payroll_action_id = :payroll_action_id
5126: and ppa.effective_date between
5127: fnd_date.canonical_to_date('''||
5128: fnd_date.date_to_canonical(l_year_start)||''') and
5129: fnd_date.canonical_to_date('''||
5130: fnd_date.date_to_canonical(l_year_end)||''')
5131: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
5132: and ppa.action_status = ''C''
5133: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'

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

5126: and ppa.effective_date between
5127: fnd_date.canonical_to_date('''||
5128: fnd_date.date_to_canonical(l_year_start)||''') and
5129: fnd_date.canonical_to_date('''||
5130: fnd_date.date_to_canonical(l_year_end)||''')
5131: and ppa.action_type in (''R'',''Q'',''V'',''B'',''I'')
5132: and ppa.action_status = ''C''
5133: and ppa.business_group_id + 0 = '||to_char(l_business_group)||'
5134: and ppa.payroll_action_id = paa.payroll_action_id