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 2152: select fnd_date.date_to_canonical(ptp.start_date),

2148: CURSOR archive_non_retro_elements ( cp_original_date_paid in varchar2,
2149: cp_element_entry_id in number,
2150: cp_run_assignment_action_id in number ) IS
2151:
2152: select fnd_date.date_to_canonical(ptp.start_date),
2153: fnd_date.date_to_canonical(ptp.end_date),
2154: hr_general.decode_lookup
2155: (DECODE (UPPER (ec.classification_name),
2156: 'EARNINGS', 'US_EARNINGS',

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

2149: cp_element_entry_id in number,
2150: cp_run_assignment_action_id in number ) IS
2151:
2152: select fnd_date.date_to_canonical(ptp.start_date),
2153: fnd_date.date_to_canonical(ptp.end_date),
2154: hr_general.decode_lookup
2155: (DECODE (UPPER (ec.classification_name),
2156: 'EARNINGS', 'US_EARNINGS',
2157: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',

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

2359: where paa.assignment_action_id = cp_asg_act_id;
2360: --Bug 6950970 starts here
2361: CURSOR get_payroll_date_earned(cp_run_action_id IN NUMBER) IS
2362: SELECT
2363: TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(ppa.date_earned))),'DD-MON-YYYY')
2364: FROM pay_assignment_actions paa,
2365: pay_payroll_actions ppa
2366: WHERE paa.assignment_action_id = cp_run_action_id
2367: AND ppa.payroll_action_id = paa.payroll_action_id;

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

2647:
2648: IF ln_flag = 0 then -- Addl Ele DFF Info Configured
2649: hr_utility.trace('Addl Ele DFF Info Configured.');
2650:
2651: SELECT TO_CHAR(TRUNC(fnd_date.canonical_to_date(fnd_date.date_to_canonical(p_curr_pymt_eff_date))),'DD-MON-YYYY')
2652: INTO lv_curr_pymt_eff_date
2653: FROM DUAL;
2654: --bug no 6950970 starts here
2655: OPEN get_payroll_date_earned (ln_run_assignment_action_id);

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

4749: */
4750: CURSOR archive_retro_elements ( cp_element_entry_id in number ,
4751: cp_run_assignment_action_id in number ) IS
4752:
4753: select fnd_date.date_to_canonical(pay_paywsmee_pkg.get_original_date_earned(cp_element_entry_id)) ,
4754: fnd_date.date_to_canonical(ptp.start_date),
4755: fnd_date.date_to_canonical(ptp.end_date),
4756: hr_general.decode_lookup
4757: (DECODE (UPPER (ec.classification_name),

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

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

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

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

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

5361: CURSOR archive_non_retro_elements ( cp_original_date_paid in varchar2,
5362: cp_element_entry_id in number,
5363: cp_run_assignment_action_id in number ) IS
5364:
5365: select fnd_date.date_to_canonical(ptp.start_date),
5366: fnd_date.date_to_canonical(ptp.end_date),
5367: hr_general.decode_lookup
5368: (DECODE (UPPER (ec.classification_name),
5369: 'EARNINGS', 'US_EARNINGS',

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

5362: cp_element_entry_id in number,
5363: cp_run_assignment_action_id in number ) IS
5364:
5365: select fnd_date.date_to_canonical(ptp.start_date),
5366: fnd_date.date_to_canonical(ptp.end_date),
5367: hr_general.decode_lookup
5368: (DECODE (UPPER (ec.classification_name),
5369: 'EARNINGS', 'US_EARNINGS',
5370: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',

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

5578: execute immediate lv_sqlstr
5579: into lv_original_date_earned ;
5580:
5581: IF lv_original_date_earned = 'AAA' THEN
5582: lv_original_date_earned := fnd_date.date_to_canonical( p_pymt_eff_date);
5583: lv_temp_AAA:= 'AAA' ;
5584: END IF;
5585: lv_original_date_earned := nvl(lv_original_date_earned ,p_pymt_eff_date);
5586:

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

5586:
5587:
5588: hr_utility.trace('lv_original_date_earned in step 53 is' || lv_original_date_earned) ;
5589:
5590: ld_original_date_paid := fnd_date.canonical_to_date(lv_original_date_earned);
5591:
5592: ln_step :=54;
5593: ln_hours := 0;
5594: ln_amount := 0;

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

5961: CURSOR archive_non_retro_elements ( cp_original_date_paid in varchar2,
5962: cp_element_entry_id in number,
5963: cp_run_assignment_action_id in number ) IS
5964:
5965: select fnd_date.date_to_canonical(ptp.start_date),
5966: fnd_date.date_to_canonical(ptp.end_date),
5967: hr_general.decode_lookup
5968: (DECODE (UPPER (ec.classification_name),
5969: 'EARNINGS', 'US_EARNINGS',

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

5962: cp_element_entry_id in number,
5963: cp_run_assignment_action_id in number ) IS
5964:
5965: select fnd_date.date_to_canonical(ptp.start_date),
5966: fnd_date.date_to_canonical(ptp.end_date),
5967: hr_general.decode_lookup
5968: (DECODE (UPPER (ec.classification_name),
5969: 'EARNINGS', 'US_EARNINGS',
5970: 'SUPPLEMENTAL EARNINGS', 'US_SUPPLEMENTAL_EARNINGS',

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

6190:
6191: hr_utility.trace('Srini lv_original_date_earned == ' || lv_original_date_earned);
6192:
6193: IF lv_original_date_earned = 'AAA' THEN
6194: lv_original_date_earned := fnd_date.date_to_canonical( p_pymt_eff_date);
6195: lv_temp_AAA:= 'AAA' ;
6196: END IF;
6197: lv_original_date_earned := nvl(lv_original_date_earned ,p_pymt_eff_date);
6198:

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

6198:
6199:
6200: hr_utility.trace('lv_original_date_earned in step 53 is' || lv_original_date_earned) ;
6201:
6202: ld_original_date_paid := fnd_date.canonical_to_date(lv_original_date_earned);
6203:
6204: ln_step :=54;
6205: ln_hours := 0;
6206: ln_amount := 0;