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.HRASSACT dependencies on PAY_PERSON_LATEST_BALANCES

Line 734: -- from pay_person_latest_balances

730: -- from pay_assignment_latest_balances
731: -- where assignment_action_id = p_assact_id)
732: -- or exists -- check for any latest balances
733: -- (select null
734: -- from pay_person_latest_balances
735: -- where assignment_action_id = p_assact_id)
736: -- or exists -- check for any latest balances
737: -- (select null
738: -- from pay_latest_balances

Line 763: -- from pay_person_latest_balances

759: -- from pay_assignment_latest_balances
760: -- where assignment_action_id = p_assact_id)
761: -- or exists -- check for any latest balances
762: -- (select null
763: -- from pay_person_latest_balances
764: -- where assignment_action_id = p_assact_id)
765: -- or exists -- check for any latest balances
766: -- (select null
767: -- from pay_latest_balances

Line 1609: from pay_person_latest_balances PLB

1605: end if;
1606: delete from pay_balance_context_values VAL
1607: where exists (
1608: select null
1609: from pay_person_latest_balances PLB
1610: where PLB.assignment_action_id = p_assact_rec.assact_id
1611: and VAL.latest_balance_id = PLB.latest_balance_id);
1612: --
1613: if g_debug then

Line 1616: delete from pay_person_latest_balances PLB

1612: --
1613: if g_debug then
1614: hr_utility.set_location('hrassact.do_assact_rollback',30);
1615: end if;
1616: delete from pay_person_latest_balances PLB
1617: where PLB.assignment_action_id = p_assact_rec.assact_id;
1618: --
1619: if g_debug then
1620: hr_utility.set_location('hrassact.do_assact_rollback',35);

Line 2347: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)

2343: l_trash_date date) is
2344: --
2345: -- Select all person latest balances to delete.
2346: cursor plbc is
2347: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2348: USE_NL (PLB) */
2349: plb.latest_balance_id
2350: from pay_defined_balances pdb,
2351: pay_person_latest_balances plb

Line 2351: pay_person_latest_balances plb

2347: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2348: USE_NL (PLB) */
2349: plb.latest_balance_id
2350: from pay_defined_balances pdb,
2351: pay_person_latest_balances plb
2352: where pdb.balance_type_id = l_balance_type_id
2353: and plb.defined_balance_id = pdb.defined_balance_id
2354: and exists (
2355: select null

Line 2398: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)

2394: and prr.status in ('P', 'PA')
2395: and nvl(rrv.result_value, '0') <> '0');
2396: --
2397: cursor platbalc is
2398: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2399: USE_NL (PLB) */
2400: plb.latest_balance_id
2401: from pay_defined_balances pdb,
2402: pay_person_latest_balances plb

Line 2402: pay_person_latest_balances plb

2398: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2399: USE_NL (PLB) */
2400: plb.latest_balance_id
2401: from pay_defined_balances pdb,
2402: pay_person_latest_balances plb
2403: where pdb.balance_type_id = l_balance_type_id
2404: and plb.defined_balance_id = pdb.defined_balance_id;
2405: --
2406: -- Select all assignment latest balances to delete.

Line 2451: from pay_person_latest_balances plb,

2447:
2448: cursor pl_feed_chk is
2449: select plb.latest_balance_id,
2450: 'P' balance_type
2451: from pay_person_latest_balances plb,
2452: pay_defined_balances pdb,
2453: pay_balance_dimensions pbd
2454: where pdb.balance_type_id = l_balance_type_id
2455: and pdb.defined_balance_id = plb.defined_balance_id

Line 2529: delete from pay_person_latest_balances PLB

2525: for plbcrec in platbalc loop
2526: delete from pay_balance_context_values BCV
2527: where BCV.latest_balance_id = plbcrec.latest_balance_id;
2528: --
2529: delete from pay_person_latest_balances PLB
2530: where PLB.latest_balance_id = plbcrec.latest_balance_id;
2531: end loop;
2532:
2533: if g_debug then

Line 2608: delete from pay_person_latest_balances PLB

2604: if l_rrv_found = 1 then
2605: delete from pay_balance_context_values BCV
2606: where BCV.latest_balance_id = plbcrec.latest_balance_id;
2607: --
2608: delete from pay_person_latest_balances PLB
2609: where PLB.latest_balance_id = plbcrec.latest_balance_id;
2610: end if;
2611: end loop;
2612: --

Line 2690: delete from pay_person_latest_balances PLB

2686: for plbcrec in plbc loop
2687: delete from pay_balance_context_values BCV
2688: where BCV.latest_balance_id = plbcrec.latest_balance_id;
2689: --
2690: delete from pay_person_latest_balances PLB
2691: where PLB.latest_balance_id = plbcrec.latest_balance_id;
2692: end loop;
2693: --
2694: if g_debug then

Line 2745: delete from pay_person_latest_balances PLB

2741: delete from pay_balance_context_values BCV
2742: where BCV.latest_balance_id = plrec.latest_balance_id;
2743: --
2744: if (plrec.balance_type = 'P') then
2745: delete from pay_person_latest_balances PLB
2746: where PLB.latest_balance_id = plrec.latest_balance_id;
2747: else
2748: delete from pay_latest_balances PLB
2749: where PLB.latest_balance_id = plrec.latest_balance_id;

Line 2806: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)

2802: procedure trash_latest_balances(l_balance_type_id number,
2803: l_trash_date date) is
2804: -- Select all person latest balances to delete.
2805: cursor plbc is
2806: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2807: USE_NL (PLB) */
2808: plb.latest_balance_id
2809: from pay_defined_balances pdb,
2810: pay_person_latest_balances plb

Line 2810: pay_person_latest_balances plb

2806: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2807: USE_NL (PLB) */
2808: plb.latest_balance_id
2809: from pay_defined_balances pdb,
2810: pay_person_latest_balances plb
2811: where pdb.balance_type_id = l_balance_type_id
2812: and plb.defined_balance_id = pdb.defined_balance_id;
2813: --
2814: -- Select all assignment latest balances to delete.

Line 2845: delete from pay_person_latest_balances PLB

2841: for plbcrec in plbc loop
2842: delete from pay_balance_context_values BCV
2843: where BCV.latest_balance_id = plbcrec.latest_balance_id;
2844: --
2845: delete from pay_person_latest_balances PLB
2846: where PLB.latest_balance_id = plbcrec.latest_balance_id;
2847: end loop;
2848: --
2849: hr_utility.set_location('hrassact.trash_latest_balances',20);

Line 2900: from pay_person_latest_balances plb

2896: -- Cursors to delete all the latest balances for an assignment.
2897: --
2898: cursor plbc (p_person_id number) is
2899: select plb.latest_balance_id
2900: from pay_person_latest_balances plb
2901: where plb.person_id = p_person_id;
2902: --
2903: cursor lbc (p_person_id number) is
2904: select lb.latest_balance_id

Line 2937: pay_person_latest_balances plb,

2933: from
2934: pay_input_values_f piv,
2935: pay_balance_feeds_f pbf,
2936: pay_defined_balances pdb,
2937: pay_person_latest_balances plb,
2938: pay_assignment_actions paa,
2939: pay_payroll_actions ppa
2940: where plb.person_id = p_person_id
2941: and piv.element_type_id = p_eletyp_id

Line 3027: delete from pay_person_latest_balances PLB

3023: for plbcrec in plbc(l_person_id) loop
3024: delete from pay_balance_context_values BCV
3025: where BCV.latest_balance_id = plbcrec.latest_balance_id;
3026: --
3027: delete from pay_person_latest_balances PLB
3028: where PLB.latest_balance_id = plbcrec.latest_balance_id;
3029: end loop;
3030: --
3031: -- We need to delete all latest balances for the

Line 3084: delete from pay_person_latest_balances PLB

3080: for plbcrec in plbc_selective(l_person_id, l_element_type_id) loop
3081: delete from pay_balance_context_values BCV
3082: where BCV.latest_balance_id = plbcrec.latest_balance_id;
3083: --
3084: delete from pay_person_latest_balances PLB
3085: where PLB.latest_balance_id = plbcrec.latest_balance_id;
3086: end loop;
3087: --
3088: -- Delete contexts and latest balances for assignment.

Line 6853: from pay_person_latest_balances pplb,

6849: nvl(pplb.prev_assignment_action_id, -9999) prev_assignment_action_id,
6850: pdb.balance_dimension_id,
6851: pdb.balance_type_id,
6852: pbf.scale
6853: from pay_person_latest_balances pplb,
6854: pay_defined_balances pdb,
6855: pay_balance_feeds_f pbf
6856: where pbf.input_value_id = p_inp_val_id
6857: and effdate between pbf.effective_start_date

Line 7532: delete from pay_person_latest_balances

7528: elsif lat_bal_type = 'P' then
7529: delete from pay_balance_context_values
7530: where latest_balance_id = lat_bal_id;
7531:
7532: delete from pay_person_latest_balances
7533: where latest_balance_id = lat_bal_id;
7534: else
7535: delete from pay_latest_balances
7536: where latest_balance_id = lat_bal_id;

Line 8285: update pay_person_latest_balances

8281: fnd_number.canonical_to_number(rrv.result_value),
8282: plb.scale,dummy_date,dummy_date,dummy_date);
8283:
8284: if l_change_flag = TRUE then
8285: update pay_person_latest_balances
8286: set assignment_action_id = plb.assignment_action_id,
8287: value = plb.value,
8288: expired_assignment_action_id = plb.expired_assignment_action_id,
8289: expired_value = plb.expired_value,