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 1310: valid_date := (fnd_date.canonical_to_date(p_effective_date) -

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

Line 1530: and fnd_date.canonical_to_date(p_effective_date) between

1526: and paa.assignment_action_id = p_assignment_action
1527: and paa.payroll_action_id = ppa.payroll_action_id
1528: and ppa.payroll_id = opmu.payroll_id
1529: and opmu.org_payment_method_id = opm.org_payment_method_id
1530: and fnd_date.canonical_to_date(p_effective_date) between
1531: opmu.effective_start_date and opmu.effective_end_date
1532: and fnd_date.canonical_to_date(p_effective_date) between
1533: rtom.effective_start_date and rtom.effective_end_date
1534: and fnd_date.canonical_to_date(p_effective_date) between

Line 1532: and fnd_date.canonical_to_date(p_effective_date) between

1528: and ppa.payroll_id = opmu.payroll_id
1529: and opmu.org_payment_method_id = opm.org_payment_method_id
1530: and fnd_date.canonical_to_date(p_effective_date) between
1531: opmu.effective_start_date and opmu.effective_end_date
1532: and fnd_date.canonical_to_date(p_effective_date) between
1533: rtom.effective_start_date and rtom.effective_end_date
1534: and fnd_date.canonical_to_date(p_effective_date) between
1535: opm.effective_start_date and opm.effective_end_date
1536: order by rtom.priority;

Line 1534: and fnd_date.canonical_to_date(p_effective_date) between

1530: and fnd_date.canonical_to_date(p_effective_date) between
1531: opmu.effective_start_date and opmu.effective_end_date
1532: and fnd_date.canonical_to_date(p_effective_date) between
1533: rtom.effective_start_date and rtom.effective_end_date
1534: and fnd_date.canonical_to_date(p_effective_date) between
1535: opm.effective_start_date and opm.effective_end_date
1536: order by rtom.priority;
1537:
1538:

Line 1568: and fnd_date.canonical_to_date(p_effective_date) between

1564: and ppm.org_payment_method_id = opm.org_payment_method_id
1565: and opm.payment_type_id = ppt.payment_type_id
1566: and opm.defined_balance_id = p_def_balance
1567: and ppm.external_account_id = pea.external_account_id (+)
1568: and fnd_date.canonical_to_date(p_effective_date) between
1569: ppm.effective_start_date and ppm.effective_end_date
1570: and fnd_date.canonical_to_date(p_effective_date) between
1571: opm.effective_start_date and opm.effective_end_date
1572: order by ppm.person_id,ppm.priority;

Line 1570: and fnd_date.canonical_to_date(p_effective_date) between

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

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

1631: pay_left := total_pay;
1632: got_payment_amount := TRUE;
1633: end if;
1634: --
1635: valid_date := (fnd_date.canonical_to_date(p_effective_date) -
1636: payments.valid_days);
1637: --
1638: -- Pay this method. Find out the amount of this payment and the
1639: -- pay left.

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

1754: pay_left := total_pay;
1755: got_payment_amount := TRUE;
1756: end if;
1757: --
1758: valid_date := (fnd_date.canonical_to_date(p_effective_date) -
1759: payments.valid_days);
1760: --
1761: -- Pay this method. Find out the amount of this payment and the
1762: -- pay left.

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

2350: and prr2.run_result_id = rrv.run_result_id
2351: and rrv.input_value_id = piv.input_value_id
2352: and rrv.result_value is not null
2353: and piv.name = 'Pay Value'
2354: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2355: piv.effective_start_date and piv.effective_end_date
2356: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2357: pet.effective_start_date and pet.effective_end_date;
2358: else

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

2352: and rrv.result_value is not null
2353: and piv.name = 'Pay Value'
2354: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2355: piv.effective_start_date and piv.effective_end_date
2356: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2357: pet.effective_start_date and pet.effective_end_date;
2358: else
2359: select fnd_number.canonical_to_number(rrv.result_value)
2360: into adj_value

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

2377: and prr2.run_result_id = rrv.run_result_id
2378: and rrv.input_value_id = piv.input_value_id
2379: and rrv.result_value is not null
2380: and piv.name = 'Pay Value'
2381: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2382: piv.effective_start_date and piv.effective_end_date
2383: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2384: pet.effective_start_date and pet.effective_end_date
2385: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between

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

2379: and rrv.result_value is not null
2380: and piv.name = 'Pay Value'
2381: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2382: piv.effective_start_date and piv.effective_end_date
2383: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2384: pet.effective_start_date and pet.effective_end_date
2385: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2386: pee.effective_start_date and pee.effective_end_date;
2387: end if;

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

2381: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2382: piv.effective_start_date and piv.effective_end_date
2383: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2384: pet.effective_start_date and pet.effective_end_date
2385: and nvl(run_date_earned, fnd_date.canonical_to_date(p_effective_date)) between
2386: pee.effective_start_date and pee.effective_end_date;
2387: end if;
2388: end if;
2389: --

Line 2462: and fnd_date.canonical_to_date(p_effective_date) between

2458: and ppm.external_account_id = pea.external_account_id (+)
2459: -- and opm.pmeth_information1 = hlu.lookup_code (+)
2460: -- and NVL(hlu.lookup_type, 'CASH_ANALYSIS') = 'CASH_ANALYSIS'
2461: -- and NVL(hlu.application_id, 800) = 800
2462: and fnd_date.canonical_to_date(p_effective_date) between
2463: ppm.effective_start_date and ppm.effective_end_date
2464: and fnd_date.canonical_to_date(p_effective_date) between
2465: opm.effective_start_date and opm.effective_end_date
2466: and ppa.date_earned between

Line 2464: and fnd_date.canonical_to_date(p_effective_date) between

2460: -- and NVL(hlu.lookup_type, 'CASH_ANALYSIS') = 'CASH_ANALYSIS'
2461: -- and NVL(hlu.application_id, 800) = 800
2462: and fnd_date.canonical_to_date(p_effective_date) between
2463: ppm.effective_start_date and ppm.effective_end_date
2464: and fnd_date.canonical_to_date(p_effective_date) between
2465: opm.effective_start_date and opm.effective_end_date
2466: and ppa.date_earned between
2467: pee.effective_start_date and pee.effective_end_date
2468: order by ppm.priority;

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

2467: pee.effective_start_date and pee.effective_end_date
2468: order by ppm.priority;
2469: --
2470: if fnd_number.canonical_to_number(p_bal_value) <> 0 then
2471: valid_date := (fnd_date.canonical_to_date(p_effective_date) -
2472: payment_details.valid_days);
2473: --
2474: -- Check magnetic tape payments for prenote.
2475: --

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

2772: hr_utility.trace('Time Def '||payments.time_def_id);
2773: hr_utility.trace('Payment Date '||payments.payment_date);
2774: --
2775: if fnd_number.canonical_to_number(l_bal_value) <> 0 then
2776: valid_date := (fnd_date.canonical_to_date(p_eff_date) -
2777: payments.valid_days);
2778: --
2779: -- Check magnetic tape payments for prenote.
2780: --

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

3157: --
3158: begin
3159: --
3160: hr_utility.trace('Enter do_prepayment');
3161: l_eff_date := fnd_date.canonical_to_date(p_effective_date);
3162: child_processed := FALSE;
3163: --
3164: create_child_actions(p_asg_act,
3165: p_ma_flag,