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_ASSIGNMENT_LATEST_BALANCES

Line 43: pay_assignment_latest_balances

39: 12010000.3 per_all_assignment_f and
40: per_periods_of_service.
41: 10-Oct-2008 salogana 115.143 7371362 Added bulk delete in
42: trash_latest_balances FOR
43: pay_assignment_latest_balances
44: 05-Aug-2008 salogana 115.142 6595092 Added bulk delete code in
45: trash_latest_balances for
46: performance improvement.
47: 26-Feb-2008 Ckesanap 115.141 6820127 Added another definition of

Line 730: -- from pay_assignment_latest_balances

726: where source_type = 'A'
727: and source_id = p_assact_id)
728: -- or exists -- check for any latest balances
729: -- (select null
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

Line 759: -- from pay_assignment_latest_balances

755: where source_type = 'A'
756: and source_id = p_assact_id)
757: -- or exists -- check for any latest balances
758: -- (select null
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

Line 1625: from pay_assignment_latest_balances ALB

1621: end if;
1622: delete from pay_balance_context_values VAL
1623: where exists (
1624: select null
1625: from pay_assignment_latest_balances ALB
1626: where ALB.assignment_action_id = p_assact_rec.assact_id
1627: and VAL.latest_balance_id = ALB.latest_balance_id);
1628: --
1629: if g_debug then

Line 1632: delete from pay_assignment_latest_balances ALB

1628: --
1629: if g_debug then
1630: hr_utility.set_location('hrassact.do_assact_rollback',40);
1631: end if;
1632: delete from pay_assignment_latest_balances ALB
1633: where ALB.assignment_action_id = p_assact_rec.assact_id;
1634: --
1635: -- If the payroll action that is being deleted is
1636: -- a Balance Adjustment (type = 'B'), then we attempt to

Line 2385: pay_assignment_latest_balances plb

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

Line 2412: pay_assignment_latest_balances plb

2408: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2409: USE_NL (PLB) */
2410: plb.latest_balance_id
2411: from pay_defined_balances pdb,
2412: pay_assignment_latest_balances plb
2413: where pdb.balance_type_id = l_balance_type_id
2414: and plb.defined_balance_id = pdb.defined_balance_id;
2415: --
2416: -- Select all latest balances to delete.

Line 2440: from pay_assignment_latest_balances alb,

2436: --
2437: -- Select the balances that are PL/SQL fed.
2438: cursor pl_feed_chk_a is
2439: select alb.latest_balance_id
2440: from pay_assignment_latest_balances alb,
2441: pay_defined_balances pdb,
2442: pay_balance_dimensions pbd
2443: where pdb.balance_type_id = l_balance_type_id
2444: and pdb.defined_balance_id = alb.defined_balance_id

Line 2472: Type t_latbal is table of pay_assignment_latest_balances.latest_balance_id%type;

2468:
2469: l_ivchk varchar2(2);
2470: l_rrv_found number := -1;
2471: --Added following type for Bug:6595092 bulk delete
2472: Type t_latbal is table of pay_assignment_latest_balances.latest_balance_id%type;
2473: lat_bal_list t_latbal;
2474: --
2475: begin
2476: g_debug := hr_utility.debug_enabled;

Line 2545: delete from pay_assignment_latest_balances ALB

2541: /* for albcrec in alatbalc loop
2542: delete from pay_balance_context_values BCV
2543: where BCV.latest_balance_id = albcrec.latest_balance_id;
2544: --
2545: delete from pay_assignment_latest_balances ALB
2546: where ALB.latest_balance_id = albcrec.latest_balance_id;
2547: end loop; */
2548:
2549: open alatbalc;

Line 2558: delete from pay_assignment_latest_balances ALB

2554: delete from pay_balance_context_values BCV
2555: where BCV.latest_balance_id = lat_bal_list(i);
2556:
2557: forall i in 1..lat_bal_list.count
2558: delete from pay_assignment_latest_balances ALB
2559: where ALB.latest_balance_id =lat_bal_list(i);
2560:
2561: exit when alatbalc%notfound;
2562: end loop;

Line 2642: delete from pay_assignment_latest_balances ALB

2638: delete from pay_balance_context_values BCV
2639: where BCV.latest_balance_id = lat_bal_list(i);
2640:
2641: forall i in 1..lat_bal_list.count
2642: delete from pay_assignment_latest_balances ALB
2643: where ALB.latest_balance_id =lat_bal_list(i);
2644:
2645: exit when alatbalc%notfound;
2646: end loop;

Line 2708: delete from pay_assignment_latest_balances ALB

2704: delete from pay_balance_context_values BCV
2705: where BCV.latest_balance_id = lat_bal_list(i);
2706:
2707: forall i in 1..lat_bal_list.count
2708: delete from pay_assignment_latest_balances ALB
2709: where ALB.latest_balance_id =lat_bal_list(i);
2710:
2711: exit when albc%notfound;
2712: end loop;

Line 2764: delete from pay_assignment_latest_balances ALB

2760: delete from pay_balance_context_values BCV
2761: where BCV.latest_balance_id = lat_bal_list(i);
2762:
2763: forall i in 1..lat_bal_list.count
2764: delete from pay_assignment_latest_balances ALB
2765: where ALB.latest_balance_id =lat_bal_list(i);
2766:
2767: exit when pl_feed_chk_a%notfound;
2768: end loop;

Line 2820: pay_assignment_latest_balances plb

2816: select /*+ ORDERED INDEX (PLB PAY_ASSIGNMENT_LATEST_BALA_FK2)
2817: USE_NL (PLB) */
2818: plb.latest_balance_id
2819: from pay_defined_balances pdb,
2820: pay_assignment_latest_balances plb
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

Line 2833: Type t_latbal is table of pay_assignment_latest_balances.latest_balance_id%type;

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;
2834: lat_bal_list t_latbal;
2835:
2836: begin
2837: hr_utility.set_location('hrassact.trash_latest_balances',10);

Line 2861: delete from pay_assignment_latest_balances ALB

2857: delete from pay_balance_context_values BCV
2858: where BCV.latest_balance_id = lat_bal_list(i);
2859:
2860: forall i in 1..lat_bal_list.count
2861: delete from pay_assignment_latest_balances ALB
2862: where ALB.latest_balance_id =lat_bal_list(i);
2863:
2864: exit when albc%notfound;
2865: end loop;

Line 2914: pay_assignment_latest_balances alb

2910: from per_periods_of_service pos,
2911: per_all_assignments_f asg,
2912: pay_assignment_actions act,
2913: pay_payroll_actions pac,
2914: pay_assignment_latest_balances alb
2915: where pos.person_id = p_person_id
2916: and asg.period_of_service_id = pos.period_of_service_id
2917: and asg.person_id = p_person_id
2918: and act.assignment_id = asg.assignment_id

Line 2956: from pay_assignment_latest_balances alb,

2952: cursor albc_selective (p_person_id number,
2953: p_eletyp_id number) is
2954: select /*+ ORDERED */
2955: alb.latest_balance_id
2956: from pay_assignment_latest_balances alb,
2957: pay_assignment_actions act,
2958: pay_payroll_actions pac,
2959: pay_defined_balances pdb,
2960: pay_balance_feeds_f pbf,

Line 3040: delete from pay_assignment_latest_balances ALB

3036: for albcrec in albc(l_person_id) loop
3037: delete from pay_balance_context_values BCV
3038: where BCV.latest_balance_id = albcrec.latest_balance_id;
3039: --
3040: delete from pay_assignment_latest_balances ALB
3041: where ALB.latest_balance_id = albcrec.latest_balance_id;
3042: end loop;
3043: --
3044: if g_debug then

Line 3098: delete from pay_assignment_latest_balances ALB

3094: for albcrec in albc_selective(l_person_id, l_element_type_id) loop
3095: delete from pay_balance_context_values BCV
3096: where BCV.latest_balance_id = albcrec.latest_balance_id;
3097: --
3098: delete from pay_assignment_latest_balances ALB
3099: where ALB.latest_balance_id = albcrec.latest_balance_id;
3100: end loop;
3101: --
3102: if g_debug then

Line 6828: from pay_assignment_latest_balances palb,

6824: nvl(palb.prev_assignment_action_id, -9999) prev_assignment_action_id,
6825: pdb.balance_dimension_id,
6826: pdb.balance_type_id,
6827: pbf.scale
6828: from pay_assignment_latest_balances palb,
6829: pay_defined_balances pdb,
6830: pay_balance_feeds_f pbf
6831: where pbf.input_value_id = p_inp_val_id
6832: and effdate between pbf.effective_start_date

Line 7526: delete from pay_assignment_latest_balances

7522: if lat_bal_type = 'A' then
7523: delete from pay_balance_context_values
7524: where latest_balance_id = lat_bal_id;
7525:
7526: delete from pay_assignment_latest_balances
7527: where latest_balance_id = lat_bal_id;
7528: elsif lat_bal_type = 'P' then
7529: delete from pay_balance_context_values
7530: where latest_balance_id = lat_bal_id;

Line 8256: update pay_assignment_latest_balances

8252: fnd_number.canonical_to_number(rrv.result_value),
8253: alb.scale, dummy_date,dummy_date,dummy_date);
8254:
8255: if l_change_flag = TRUE then
8256: update pay_assignment_latest_balances
8257: set assignment_action_id = alb.assignment_action_id,
8258: value = alb.value,
8259: expired_assignment_action_id = alb.expired_assignment_action_id,
8260: expired_value = alb.expired_value,