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.HR_PRE_PAY dependencies on FND_DATE

Line 99: and fnd_date.canonical_to_date(p_effective_date) between

95: and ppm.external_account_id = pea.external_account_id (+)
96: -- and opm.pmeth_information1 = hlu.lookup_code (+)
97: -- and NVL(hlu.lookup_type, 'CASH_ANALYSIS') = 'CASH_ANALYSIS'
98: -- and NVL(hlu.application_id, 800) = 800
99: and fnd_date.canonical_to_date(p_effective_date) between
100: ppm.effective_start_date and ppm.effective_end_date
101: and fnd_date.canonical_to_date(p_effective_date) between
102: opm.effective_start_date and opm.effective_end_date
103: order by ppm.person_id,ppm.priority;

Line 101: and fnd_date.canonical_to_date(p_effective_date) between

97: -- and NVL(hlu.lookup_type, 'CASH_ANALYSIS') = 'CASH_ANALYSIS'
98: -- and NVL(hlu.application_id, 800) = 800
99: and fnd_date.canonical_to_date(p_effective_date) between
100: ppm.effective_start_date and ppm.effective_end_date
101: and fnd_date.canonical_to_date(p_effective_date) between
102: opm.effective_start_date and opm.effective_end_date
103: order by ppm.person_id,ppm.priority;
104: --
105: -- Coinage cursor. fetch all monetary units of a currency in order of value

Line 1315: valid_date := (fnd_date.canonical_to_date(p_effective_date) -

1311: prenote_default,found);
1312: --
1313: for payments in g_pp_methods(p_assignment, p_effective_date,
1314: p_def_balance) loop
1315: valid_date := (fnd_date.canonical_to_date(p_effective_date) -
1316: payments.valid_days);
1317: --
1318: -- put code here to derive override org payment method
1319: -- when external account id is null

Line 1535: and fnd_date.canonical_to_date(p_effective_date) between

1531: and paa.assignment_action_id = p_assignment_action
1532: and paa.payroll_action_id = ppa.payroll_action_id
1533: and ppa.payroll_id = opmu.payroll_id
1534: and opmu.org_payment_method_id = opm.org_payment_method_id
1535: and fnd_date.canonical_to_date(p_effective_date) between
1536: opmu.effective_start_date and opmu.effective_end_date
1537: and fnd_date.canonical_to_date(p_effective_date) between
1538: rtom.effective_start_date and rtom.effective_end_date
1539: and fnd_date.canonical_to_date(p_effective_date) between

Line 1537: and fnd_date.canonical_to_date(p_effective_date) between

1533: and ppa.payroll_id = opmu.payroll_id
1534: and opmu.org_payment_method_id = opm.org_payment_method_id
1535: and fnd_date.canonical_to_date(p_effective_date) between
1536: opmu.effective_start_date and opmu.effective_end_date
1537: and fnd_date.canonical_to_date(p_effective_date) between
1538: rtom.effective_start_date and rtom.effective_end_date
1539: and fnd_date.canonical_to_date(p_effective_date) between
1540: opm.effective_start_date and opm.effective_end_date
1541: order by rtom.priority;

Line 1539: and fnd_date.canonical_to_date(p_effective_date) between

1535: and fnd_date.canonical_to_date(p_effective_date) between
1536: opmu.effective_start_date and opmu.effective_end_date
1537: and fnd_date.canonical_to_date(p_effective_date) between
1538: rtom.effective_start_date and rtom.effective_end_date
1539: and fnd_date.canonical_to_date(p_effective_date) between
1540: opm.effective_start_date and opm.effective_end_date
1541: order by rtom.priority;
1542:
1543:

Line 1573: and fnd_date.canonical_to_date(p_effective_date) between

1569: and ppm.org_payment_method_id = opm.org_payment_method_id
1570: and opm.payment_type_id = ppt.payment_type_id
1571: and opm.defined_balance_id = p_def_balance
1572: and ppm.external_account_id = pea.external_account_id (+)
1573: and fnd_date.canonical_to_date(p_effective_date) between
1574: ppm.effective_start_date and ppm.effective_end_date
1575: and fnd_date.canonical_to_date(p_effective_date) between
1576: opm.effective_start_date and opm.effective_end_date
1577: order by ppm.person_id,ppm.priority;

Line 1575: and fnd_date.canonical_to_date(p_effective_date) between

1571: and opm.defined_balance_id = p_def_balance
1572: and ppm.external_account_id = pea.external_account_id (+)
1573: and fnd_date.canonical_to_date(p_effective_date) between
1574: ppm.effective_start_date and ppm.effective_end_date
1575: and fnd_date.canonical_to_date(p_effective_date) between
1576: opm.effective_start_date and opm.effective_end_date
1577: order by ppm.person_id,ppm.priority;
1578: --
1579: -- Coinage cursor. fetch all monetary units of a currency in order of value

Line 1640: valid_date := (fnd_date.canonical_to_date(p_effective_date) -

1636: pay_left := total_pay;
1637: got_payment_amount := TRUE;
1638: end if;
1639: --
1640: valid_date := (fnd_date.canonical_to_date(p_effective_date) -
1641: payments.valid_days);
1642: --
1643: -- Pay this method. Find out the amount of this payment and the
1644: -- pay left.

Line 1763: valid_date := (fnd_date.canonical_to_date(p_effective_date) -

1759: pay_left := total_pay;
1760: got_payment_amount := TRUE;
1761: end if;
1762: --
1763: valid_date := (fnd_date.canonical_to_date(p_effective_date) -
1764: payments.valid_days);
1765: --
1766: -- Pay this method. Find out the amount of this payment and the
1767: -- pay left.

Line 2363: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between

2359: and prr2.run_result_id = rrv.run_result_id
2360: and rrv.input_value_id = piv.input_value_id
2361: and rrv.result_value is not null
2362: and piv.name = 'Pay Value'
2363: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2364: piv.effective_start_date and piv.effective_end_date
2365: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2366: pet.effective_start_date and pet.effective_end_date;
2367: else

Line 2365: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between

2361: and rrv.result_value is not null
2362: and piv.name = 'Pay Value'
2363: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2364: piv.effective_start_date and piv.effective_end_date
2365: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2366: pet.effective_start_date and pet.effective_end_date;
2367: else
2368: select fnd_number.canonical_to_number(rrv.result_value)
2369: into adj_value

Line 2390: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between

2386: and prr2.run_result_id = rrv.run_result_id
2387: and rrv.input_value_id = piv.input_value_id
2388: and rrv.result_value is not null
2389: and piv.name = 'Pay Value'
2390: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2391: piv.effective_start_date and piv.effective_end_date
2392: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2393: pet.effective_start_date and pet.effective_end_date
2394: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between

Line 2392: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between

2388: and rrv.result_value is not null
2389: and piv.name = 'Pay Value'
2390: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2391: piv.effective_start_date and piv.effective_end_date
2392: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2393: pet.effective_start_date and pet.effective_end_date
2394: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2395: pee.effective_start_date and pee.effective_end_date;
2396: end if;

Line 2394: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between

2390: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2391: piv.effective_start_date and piv.effective_end_date
2392: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2393: pet.effective_start_date and pet.effective_end_date
2394: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2395: pee.effective_start_date and pee.effective_end_date;
2396: end if;
2397: end if;
2398: --

Line 2488: and fnd_date.canonical_to_date(p_effective_date) between

2484: and ppm.external_account_id = pea.external_account_id (+)
2485: -- and opm.pmeth_information1 = hlu.lookup_code (+)
2486: -- and NVL(hlu.lookup_type, 'CASH_ANALYSIS') = 'CASH_ANALYSIS'
2487: -- and NVL(hlu.application_id, 800) = 800
2488: and fnd_date.canonical_to_date(p_effective_date) between
2489: ppm.effective_start_date and ppm.effective_end_date
2490: and fnd_date.canonical_to_date(p_effective_date) between
2491: opm.effective_start_date and opm.effective_end_date
2492: and ( (ppa.date_earned between

Line 2490: and fnd_date.canonical_to_date(p_effective_date) between

2486: -- and NVL(hlu.lookup_type, 'CASH_ANALYSIS') = 'CASH_ANALYSIS'
2487: -- and NVL(hlu.application_id, 800) = 800
2488: and fnd_date.canonical_to_date(p_effective_date) between
2489: ppm.effective_start_date and ppm.effective_end_date
2490: and fnd_date.canonical_to_date(p_effective_date) between
2491: opm.effective_start_date and opm.effective_end_date
2492: and ( (ppa.date_earned between
2493: pee.effective_start_date and pee.effective_end_date)
2494: OR exists

Line 2507: valid_date := (fnd_date.canonical_to_date(p_effective_date) -

2503: order by ppm.priority;
2504: --
2505: hr_utility.trace('Entered pay third party location 1 ');
2506: if fnd_number.canonical_to_number(p_bal_value) <> 0 then
2507: valid_date := (fnd_date.canonical_to_date(p_effective_date) -
2508: payment_details.valid_days);
2509: --
2510: -- Check magnetic tape payments for prenote.
2511: --

Line 2814: valid_date := (fnd_date.canonical_to_date(p_eff_date) -

2810: hr_utility.trace('Time Def '||payments.time_def_id);
2811: hr_utility.trace('Payment Date '||payments.payment_date);
2812: --
2813: if fnd_number.canonical_to_number(l_bal_value) <> 0 then
2814: valid_date := (fnd_date.canonical_to_date(p_eff_date) -
2815: payments.valid_days);
2816: --
2817: -- Check magnetic tape payments for prenote.
2818: --

Line 3199: l_eff_date := fnd_date.canonical_to_date(p_effective_date);

3195: --
3196: begin
3197: --
3198: hr_utility.trace('Enter do_prepayment');
3199: l_eff_date := fnd_date.canonical_to_date(p_effective_date);
3200: child_processed := FALSE;
3201: --
3202: create_child_actions(p_asg_act,
3203: p_ma_flag,