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_LATEST_BALANCES

Line 165: pay_latest_balances.

161: initialisations.
162: 16-DEC-2003 tbattoo 115.91 Fix to mantain latest balances
163: 11-DEC-2003 tbattoo 115.90 Fix to mantain latest balances
164: 09-DEC-2003 nbristow 115.89 Changes to maintain
165: pay_latest_balances.
166: 24-NOV-2003 alogue 115.88 3262314 Performance enhancement to
167: previous change.
168: 24-NOV-2003 alogue 115.87 3262314 Performance enhancement to
169: previous change.

Line 181: pay_latest_balances table

177: per_all_people_f and
178: pay_all_payrolls_f. Performance
179: fix to seqper cursors.
180: 03-NOV-2003 tbattoo 115.83 support for sparse matrix and
181: pay_latest_balances table
182: 17-OCT-2003 alogue 115.82 Tuned get_rr_values cursor
183: in set_action_context.
184: 14-OCT-2003 alogue 115.81 3166638 Performance fix to quickpay
185: assignment action creation.

Line 738: -- from pay_latest_balances

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
739: -- where assignment_action_id = p_assact_id)
740: or exists -- check for updates to REEs
741: (select null
742: from pay_element_entries_f

Line 767: -- from pay_latest_balances

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
768: -- where assignment_action_id = p_assact_id)
769: or exists -- check for updates to REEs
770: (select null
771: from pay_element_entries_f

Line 2367: pay_latest_balances lb

2363: cursor lbc is
2364: select
2365: lb.latest_balance_id
2366: from pay_defined_balances pdb,
2367: pay_latest_balances lb
2368: where pdb.balance_type_id = l_balance_type_id
2369: and lb.defined_balance_id = pdb.defined_balance_id
2370: and exists (
2371: select null

Line 2418: select /*+ ORDERED INDEX (PLB PAY_LATEST_BALANCES_FK1)

2414: and plb.defined_balance_id = pdb.defined_balance_id;
2415: --
2416: -- Select all latest balances to delete.
2417: cursor latbalc is
2418: select /*+ ORDERED INDEX (PLB PAY_LATEST_BALANCES_FK1)
2419: USE_NL (PLB) */
2420: plb.latest_balance_id
2421: from pay_defined_balances pdb,
2422: pay_latest_balances plb

Line 2422: pay_latest_balances plb

2418: select /*+ ORDERED INDEX (PLB PAY_LATEST_BALANCES_FK1)
2419: USE_NL (PLB) */
2420: plb.latest_balance_id
2421: from pay_defined_balances pdb,
2422: pay_latest_balances plb
2423: where pdb.balance_type_id = l_balance_type_id
2424: and plb.defined_balance_id = pdb.defined_balance_id;
2425: --
2426: -- Select if run result value exists for input value

Line 2461: from pay_latest_balances plb,

2457: and pbd.feed_checking_type = 'F'
2458: union
2459: select plb.latest_balance_id,
2460: 'B' balance_type
2461: from pay_latest_balances plb,
2462: pay_defined_balances pdb,
2463: pay_balance_dimensions pbd
2464: where pdb.balance_type_id = l_balance_type_id
2465: and pdb.defined_balance_id = plb.defined_balance_id

Line 2573: delete from pay_latest_balances LB

2569: --
2570: -- Delete all latest Balanaces.
2571: for lbcrec in latbalc loop
2572: --
2573: delete from pay_latest_balances LB
2574: where LB.latest_balance_id = lbcrec.latest_balance_id;
2575: end loop;
2576: --
2577: end if;

Line 2672: delete from pay_latest_balances ALB

2668: end if;
2669: close ivchk;
2670: end if;
2671: if l_rrv_found = 1 then
2672: delete from pay_latest_balances ALB
2673: where ALB.latest_balance_id = lbcrec.latest_balance_id;
2674: end if;
2675: end loop;
2676:

Line 2725: delete from pay_latest_balances ALB

2721: hr_utility.set_location('hrassact.trash_latest_balances',70);
2722: end if;
2723: --
2724: for lbcrec in lbc loop
2725: delete from pay_latest_balances ALB
2726: where ALB.latest_balance_id = lbcrec.latest_balance_id;
2727: end loop;
2728: --
2729: end if;

Line 2748: delete from pay_latest_balances PLB

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;
2750: end if;
2751: --
2752: end loop;

Line 2825: select /*+ ORDERED INDEX (LB PAY_LATEST_BALANCES_FK1)

2821: where pdb.balance_type_id = l_balance_type_id
2822: and plb.defined_balance_id = pdb.defined_balance_id;
2823: -- Select all latest balances to delete.
2824: cursor lbc is
2825: select /*+ ORDERED INDEX (LB PAY_LATEST_BALANCES_FK1)
2826: USE_NL (LB) */
2827: lb.latest_balance_id
2828: from pay_defined_balances pdb,
2829: pay_latest_balances lb

Line 2829: pay_latest_balances lb

2825: select /*+ ORDERED INDEX (LB PAY_LATEST_BALANCES_FK1)
2826: USE_NL (LB) */
2827: lb.latest_balance_id
2828: from pay_defined_balances pdb,
2829: pay_latest_balances lb
2830: where pdb.balance_type_id = l_balance_type_id
2831: and lb.defined_balance_id = pdb.defined_balance_id;
2832:
2833: Type t_latbal is table of pay_assignment_latest_balances.latest_balance_id%type;

Line 2875: delete from pay_latest_balances ALB

2871:
2872: --
2873: hr_utility.set_location('hrassact.trash_latest_balances',30);
2874: for lbcrec in lbc loop
2875: delete from pay_latest_balances ALB
2876: where ALB.latest_balance_id = lbcrec.latest_balance_id;
2877: end loop;
2878: hr_utility.set_location('hrassact.trash_latest_balances',40);
2879: --

Line 2905: from pay_latest_balances lb

2901: where plb.person_id = p_person_id;
2902: --
2903: cursor lbc (p_person_id number) is
2904: select lb.latest_balance_id
2905: from pay_latest_balances lb
2906: where lb.person_id = p_person_id;
2907: --
2908: cursor albc (p_person_id number) is
2909: select /*+ ORDERED */ alb.latest_balance_id

Line 2987: pay_latest_balances plb,

2983: from
2984: pay_input_values_f piv,
2985: pay_balance_feeds_f pbf,
2986: pay_defined_balances pdb,
2987: pay_latest_balances plb,
2988: pay_assignment_actions paa,
2989: pay_payroll_actions ppa
2990: where plb.person_id = p_person_id
2991: and piv.element_type_id = p_eletyp_id

Line 3048: delete from pay_latest_balances ALB

3044: if g_debug then
3045: hr_utility.set_location('hrassact.del_latest_balances',45);
3046: end if;
3047: for lbcrec in lbc(l_person_id) loop
3048: delete from pay_latest_balances ALB
3049: where ALB.latest_balance_id = lbcrec.latest_balance_id;
3050: end loop;
3051: else
3052: --

Line 3106: delete from pay_latest_balances ALB

3102: if g_debug then
3103: hr_utility.set_location('hrassact.del_latest_balances',85);
3104: end if;
3105: for lbcrec in lbc_selective(l_person_id, l_element_type_id) loop
3106: delete from pay_latest_balances ALB
3107: where ALB.latest_balance_id = lbcrec.latest_balance_id;
3108: end loop;
3109: end if;
3110: --

Line 6795: from pay_latest_balances plb,

6791: plb.prev_expiry_date,
6792: pdb.balance_dimension_id,
6793: pdb.balance_type_id,
6794: pbf.scale
6795: from pay_latest_balances plb,
6796: pay_defined_balances pdb,
6797: pay_balance_feeds_f pbf
6798: where pbf.input_value_id = p_inp_val_id
6799: and effdate between pbf.effective_start_date

Line 7089: from pay_latest_balances

7085: l_tax_group,
7086: l_payroll_id,
7087: l_local_unit_id,
7088: l_organization_id
7089: from pay_latest_balances
7090: where p_lat_bal_id = latest_balance_id;
7091:
7092: if g_debug then
7093: hr_utility.set_location (c_indent, 1);

Line 7535: delete from pay_latest_balances

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;
7537:
7538: end if;
7539: -- or recalculate latest balance

Line 8316: update pay_latest_balances

8312: fnd_number.canonical_to_number(rrv.result_value),
8313: lb.scale,lb.expiry_date, lb.expired_date,lb.prev_expiry_date);
8314:
8315: if l_change_flag = TRUE then
8316: update pay_latest_balances
8317: set assignment_action_id = lb.assignment_action_id,
8318: value = lb.value,
8319: expiry_date = lb.expiry_date,
8320: expired_assignment_action_id = lb.expired_assignment_action_id,