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

Line 1812: select fnd_date.date_to_canonical(ptp.start_date),

1808: CURSOR archive_non_retro_elements ( cp_original_date_paid in varchar2,
1809: cp_element_entry_id in number,
1810: cp_run_assignment_action_id in number ) IS
1811:
1812: select fnd_date.date_to_canonical(ptp.start_date),
1813: fnd_date.date_to_canonical(ptp.end_date),
1814: hr_general.decode_lookup
1815: (DECODE (UPPER (ec.classification_name),
1816: 'EARNINGS', 'US_EARNINGS',

Line 1813: fnd_date.date_to_canonical(ptp.end_date),

1809: cp_element_entry_id in number,
1810: cp_run_assignment_action_id in number ) IS
1811:
1812: select fnd_date.date_to_canonical(ptp.start_date),
1813: fnd_date.date_to_canonical(ptp.end_date),
1814: hr_general.decode_lookup
1815: (DECODE (UPPER (ec.classification_name),
1816: 'EARNINGS', 'US_EARNINGS',
1817: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',

Line 2006: TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(ppa.date_earned))),'DD-MON-YYYY')

2002: where paa.assignment_action_id = cp_asg_act_id;
2003: --Bug 6950970 starts here
2004: CURSOR get_payroll_date_earned(cp_run_action_id IN NUMBER) IS
2005: SELECT
2006: TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(ppa.date_earned))),'DD-MON-YYYY')
2007: FROM pay_assignment_actions paa,
2008: pay_payroll_actions ppa
2009: WHERE paa.assignment_action_id = cp_run_action_id
2010: AND ppa.payroll_action_id = paa.payroll_action_id;

Line 2200: SELECT TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_curr_pymt_eff_date))),'DD-MON-YYYY')

2196:
2197: IF ln_flag = 0 then -- Addl Ele DFF Info Configured
2198: hr_utility.trace('Addl Ele DFF Info Configured.');
2199:
2200: SELECT TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_curr_pymt_eff_date))),'DD-MON-YYYY')
2201: INTO lv_curr_pymt_eff_date
2202: FROM DUAL;
2203: --bug no 6950970 starts here
2204: OPEN get_payroll_date_earned (ln_run_assignment_action_id);

Line 4259: select fnd_date.date_to_canonical(pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)) ,

4255: */
4256: CURSOR archive_retro_elements ( cp_element_entry_id in number ,
4257: cp_run_assignment_action_id in number ) IS
4258:
4259: select fnd_date.date_to_canonical(pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)) ,
4260: fnd_date.date_to_canonical(ptp.start_date),
4261: fnd_date.date_to_canonical(ptp.end_date),
4262: hr_general.decode_lookup
4263: (DECODE (UPPER (ec.classification_name),

Line 4260: fnd_date.date_to_canonical(ptp.start_date),

4256: CURSOR archive_retro_elements ( cp_element_entry_id in number ,
4257: cp_run_assignment_action_id in number ) IS
4258:
4259: select fnd_date.date_to_canonical(pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)) ,
4260: fnd_date.date_to_canonical(ptp.start_date),
4261: fnd_date.date_to_canonical(ptp.end_date),
4262: hr_general.decode_lookup
4263: (DECODE (UPPER (ec.classification_name),
4264: 'EARNINGS', 'US_EARNINGS',

Line 4261: fnd_date.date_to_canonical(ptp.end_date),

4257: cp_run_assignment_action_id in number ) IS
4258:
4259: select fnd_date.date_to_canonical(pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)) ,
4260: fnd_date.date_to_canonical(ptp.start_date),
4261: fnd_date.date_to_canonical(ptp.end_date),
4262: hr_general.decode_lookup
4263: (DECODE (UPPER (ec.classification_name),
4264: 'EARNINGS', 'US_EARNINGS',
4265: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',

Line 4755: select fnd_date.date_to_canonical(ptp.start_date),

4751: CURSOR archive_non_retro_elements ( cp_original_date_paid in varchar2,
4752: cp_element_entry_id in number,
4753: cp_run_assignment_action_id in number ) IS
4754:
4755: select fnd_date.date_to_canonical(ptp.start_date),
4756: fnd_date.date_to_canonical(ptp.end_date),
4757: hr_general.decode_lookup
4758: (DECODE (UPPER (ec.classification_name),
4759: 'EARNINGS', 'US_EARNINGS',

Line 4756: fnd_date.date_to_canonical(ptp.end_date),

4752: cp_element_entry_id in number,
4753: cp_run_assignment_action_id in number ) IS
4754:
4755: select fnd_date.date_to_canonical(ptp.start_date),
4756: fnd_date.date_to_canonical(ptp.end_date),
4757: hr_general.decode_lookup
4758: (DECODE (UPPER (ec.classification_name),
4759: 'EARNINGS', 'US_EARNINGS',
4760: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',

Line 4961: lv_original_date_earned := fnd_date.date_to_canonical( p_pymt_eff_date);

4957: execute immediate lv_sqlstr
4958: into lv_original_date_earned ;
4959:
4960: IF lv_original_date_earned = 'AAA' THEN
4961: lv_original_date_earned := fnd_date.date_to_canonical( p_pymt_eff_date);
4962: lv_temp_AAA:= 'AAA' ;
4963: END IF;
4964: lv_original_date_earned := nvl(lv_original_date_earned ,p_pymt_eff_date);
4965:

Line 4969: ld_original_date_paid := fnd_date.canonical_to_date(lv_original_date_earned);

4965:
4966:
4967: hr_utility.trace('lv_original_date_earned in step 53 is' || lv_original_date_earned) ;
4968:
4969: ld_original_date_paid := fnd_date.canonical_to_date(lv_original_date_earned);
4970:
4971: ln_step :=54;
4972: ln_hours := 0;
4973: ln_amount := 0;