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 766: -- from pay_person_latest_balances

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

Line 795: -- from pay_person_latest_balances

791: -- from pay_assignment_latest_balances
792: -- where assignment_action_id = p_assact_id)
793: -- or exists -- check for any latest balances
794: -- (select null
795: -- from pay_person_latest_balances
796: -- where assignment_action_id = p_assact_id)
797: -- or exists -- check for any latest balances
798: -- (select null
799: -- from pay_latest_balances

Line 1641: from pay_person_latest_balances PLB

1637: end if;
1638: delete from pay_balance_context_values VAL
1639: where exists (
1640: select null
1641: from pay_person_latest_balances PLB
1642: where PLB.assignment_action_id = p_assact_rec.assact_id
1643: and VAL.latest_balance_id = PLB.latest_balance_id);
1644: --
1645: if g_debug then

Line 1648: delete from pay_person_latest_balances PLB

1644: --
1645: if g_debug then
1646: hr_utility.set_location('hrassact.do_assact_rollback',30);
1647: end if;
1648: delete from pay_person_latest_balances PLB
1649: where PLB.assignment_action_id = p_assact_rec.assact_id;
1650: --
1651: if g_debug then
1652: hr_utility.set_location('hrassact.do_assact_rollback',35);

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

2375: l_trash_date date) is
2376: --
2377: -- Select all person latest balances to delete.
2378: cursor plbc is
2379: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2380: USE_NL (PLB) */
2381: plb.latest_balance_id
2382: from pay_defined_balances pdb,
2383: pay_person_latest_balances plb

Line 2383: pay_person_latest_balances plb

2379: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2380: USE_NL (PLB) */
2381: plb.latest_balance_id
2382: from pay_defined_balances pdb,
2383: pay_person_latest_balances plb
2384: where pdb.balance_type_id = l_balance_type_id
2385: and plb.defined_balance_id = pdb.defined_balance_id
2386: and exists (
2387: select null

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

2426: and prr.status in ('P', 'PA')
2427: and nvl(rrv.result_value, '0') <> '0');
2428: --
2429: cursor platbalc is
2430: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2431: USE_NL (PLB) */
2432: plb.latest_balance_id
2433: from pay_defined_balances pdb,
2434: pay_person_latest_balances plb

Line 2434: pay_person_latest_balances plb

2430: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2431: USE_NL (PLB) */
2432: plb.latest_balance_id
2433: from pay_defined_balances pdb,
2434: pay_person_latest_balances plb
2435: where pdb.balance_type_id = l_balance_type_id
2436: and plb.defined_balance_id = pdb.defined_balance_id;
2437: --
2438: -- Select all assignment latest balances to delete.

Line 2483: from pay_person_latest_balances plb,

2479:
2480: cursor pl_feed_chk is
2481: select plb.latest_balance_id,
2482: 'P' balance_type
2483: from pay_person_latest_balances plb,
2484: pay_defined_balances pdb,
2485: pay_balance_dimensions pbd
2486: where pdb.balance_type_id = l_balance_type_id
2487: and pdb.defined_balance_id = plb.defined_balance_id

Line 2557: delete from pay_person_latest_balances PLB

2553: for plbcrec in platbalc loop
2554: delete from pay_balance_context_values BCV
2555: where BCV.latest_balance_id = plbcrec.latest_balance_id;
2556: --
2557: delete from pay_person_latest_balances PLB
2558: where PLB.latest_balance_id = plbcrec.latest_balance_id;
2559: end loop;
2560:
2561: if g_debug then

Line 2636: delete from pay_person_latest_balances PLB

2632: if l_rrv_found = 1 then
2633: delete from pay_balance_context_values BCV
2634: where BCV.latest_balance_id = plbcrec.latest_balance_id;
2635: --
2636: delete from pay_person_latest_balances PLB
2637: where PLB.latest_balance_id = plbcrec.latest_balance_id;
2638: end if;
2639: end loop;
2640: --

Line 2709: delete from pay_person_latest_balances PLB

2705: for plbcrec in plbc loop
2706: delete from pay_balance_context_values BCV
2707: where BCV.latest_balance_id = plbcrec.latest_balance_id;
2708: --
2709: delete from pay_person_latest_balances PLB
2710: where PLB.latest_balance_id = plbcrec.latest_balance_id;
2711: end loop;
2712: --
2713: if g_debug then

Line 2763: delete from pay_person_latest_balances PLB

2759: delete from pay_balance_context_values BCV
2760: where BCV.latest_balance_id = plrec.latest_balance_id;
2761: --
2762: if (plrec.balance_type = 'P') then
2763: delete from pay_person_latest_balances PLB
2764: where PLB.latest_balance_id = plrec.latest_balance_id;
2765: else
2766: delete from pay_latest_balances PLB
2767: where PLB.latest_balance_id = plrec.latest_balance_id;

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

2819: procedure trash_latest_balances(l_balance_type_id number,
2820: l_trash_date date) is
2821: -- Select all person latest balances to delete.
2822: cursor plbc is
2823: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2824: USE_NL (PLB) */
2825: plb.latest_balance_id
2826: from pay_defined_balances pdb,
2827: pay_person_latest_balances plb

Line 2827: pay_person_latest_balances plb

2823: select /*+ ORDERED INDEX (PLB PAY_PERSON_LATEST_BALANCES_FK1)
2824: USE_NL (PLB) */
2825: plb.latest_balance_id
2826: from pay_defined_balances pdb,
2827: pay_person_latest_balances plb
2828: where pdb.balance_type_id = l_balance_type_id
2829: and plb.defined_balance_id = pdb.defined_balance_id;
2830: --
2831: -- Select all assignment latest balances to delete.

Line 2862: delete from pay_person_latest_balances PLB

2858: for plbcrec in plbc loop
2859: delete from pay_balance_context_values BCV
2860: where BCV.latest_balance_id = plbcrec.latest_balance_id;
2861: --
2862: delete from pay_person_latest_balances PLB
2863: where PLB.latest_balance_id = plbcrec.latest_balance_id;
2864: end loop;
2865: --
2866: hr_utility.set_location('hrassact.trash_latest_balances',20);

Line 2917: from pay_person_latest_balances plb

2913: -- Cursors to delete all the latest balances for an assignment.
2914: --
2915: cursor plbc (p_person_id number) is
2916: select plb.latest_balance_id
2917: from pay_person_latest_balances plb
2918: where plb.person_id = p_person_id;
2919: --
2920: cursor lbc (p_person_id number) is
2921: select lb.latest_balance_id

Line 2954: pay_person_latest_balances plb,

2950: from
2951: pay_input_values_f piv,
2952: pay_balance_feeds_f pbf,
2953: pay_defined_balances pdb,
2954: pay_person_latest_balances plb,
2955: pay_assignment_actions paa,
2956: pay_payroll_actions ppa
2957: where plb.person_id = p_person_id
2958: and piv.element_type_id = p_eletyp_id

Line 3044: delete from pay_person_latest_balances PLB

3040: for plbcrec in plbc(l_person_id) loop
3041: delete from pay_balance_context_values BCV
3042: where BCV.latest_balance_id = plbcrec.latest_balance_id;
3043: --
3044: delete from pay_person_latest_balances PLB
3045: where PLB.latest_balance_id = plbcrec.latest_balance_id;
3046: end loop;
3047: --
3048: -- We need to delete all latest balances for the

Line 3101: delete from pay_person_latest_balances PLB

3097: for plbcrec in plbc_selective(l_person_id, l_element_type_id) loop
3098: delete from pay_balance_context_values BCV
3099: where BCV.latest_balance_id = plbcrec.latest_balance_id;
3100: --
3101: delete from pay_person_latest_balances PLB
3102: where PLB.latest_balance_id = plbcrec.latest_balance_id;
3103: end loop;
3104: --
3105: -- Delete contexts and latest balances for assignment.

Line 7117: from pay_person_latest_balances pplb,

7113: nvl(pplb.prev_assignment_action_id, -9999) prev_assignment_action_id,
7114: pdb.balance_dimension_id,
7115: pdb.balance_type_id,
7116: pbf.scale
7117: from pay_person_latest_balances pplb,
7118: pay_defined_balances pdb,
7119: pay_balance_feeds_f pbf
7120: where pbf.input_value_id = p_inp_val_id
7121: and effdate between pbf.effective_start_date

Line 7797: delete from pay_person_latest_balances

7793: elsif lat_bal_type = 'P' then
7794: delete from pay_balance_context_values
7795: where latest_balance_id = lat_bal_id;
7796:
7797: delete from pay_person_latest_balances
7798: where latest_balance_id = lat_bal_id;
7799: else
7800: delete from pay_latest_balances
7801: where latest_balance_id = lat_bal_id;

Line 8547: update pay_person_latest_balances

8543: fnd_number.canonical_to_number(rrv.result_value),
8544: plb.scale,dummy_date,dummy_date,dummy_date);
8545:
8546: if l_change_flag = TRUE then
8547: update pay_person_latest_balances
8548: set assignment_action_id = plb.assignment_action_id,
8549: value = plb.value,
8550: expired_assignment_action_id = plb.expired_assignment_action_id,
8551: expired_value = plb.expired_value,