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_BALANCE_CONTEXT_VALUES

Line 507: pay_balance_context_values

503: Delete pre_payment rows for
504: QuickPay Pre-Payment process.
505: 25-NOV-1994 DSAXBY 40.22 Change in params to qpassact.
506: 26-OCT-1994 DSAXBY 40.21 Delete from the
507: pay_balance_context_values
508: table where necessary.
509: Set time_period_id for
510: balance adjustments.
511: Created public versions of

Line 1606: delete from pay_balance_context_values VAL

1602: -- Start with any balance context values.
1603: if g_debug then
1604: hr_utility.set_location('hrassact.do_assact_rollback',25);
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

Line 1622: delete from pay_balance_context_values VAL

1618: --
1619: if g_debug then
1620: hr_utility.set_location('hrassact.do_assact_rollback',35);
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

Line 2526: delete from pay_balance_context_values BCV

2522: end if;
2523: -- Delete all balance context values and
2524: -- person latest balances.
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;

Line 2542: delete from pay_balance_context_values BCV

2538:
2539: --Commented the following and added a block with cusrsor and bulk delete
2540: --for Bug:6595092
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;

Line 2554: delete from pay_balance_context_values BCV

2550: loop
2551: fetch alatbalc bulk collect into lat_bal_list limit 100000;
2552:
2553: forall i in 1..lat_bal_list.count
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

Line 2605: delete from pay_balance_context_values BCV

2601: end if;
2602: close ivchk;
2603: end if;
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;

Line 2638: delete from pay_balance_context_values BCV

2634: loop
2635: fetch alatbalc bulk collect into lat_bal_list limit 100000;
2636:
2637: forall i in 1..lat_bal_list.count
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

Line 2687: delete from pay_balance_context_values BCV

2683: end if;
2684: -- Delete all balance context values and
2685: -- person latest balances.
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;

Line 2704: delete from pay_balance_context_values BCV

2700: loop
2701: fetch albc bulk collect into lat_bal_list limit 100000;
2702:
2703: forall i in 1..lat_bal_list.count
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

Line 2741: delete from pay_balance_context_values BCV

2737: if g_debug then
2738: hr_utility.set_location('hrassact.trash_latest_balances',100);
2739: end if;
2740:
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

Line 2760: delete from pay_balance_context_values BCV

2756: loop
2757: fetch pl_feed_chk_a bulk collect into lat_bal_list limit 100000;
2758:
2759: forall i in 1..lat_bal_list.count
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

Line 2842: delete from pay_balance_context_values BCV

2838: --
2839: -- Delete all balance context values and
2840: -- person latest balances.
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;

Line 2857: delete from pay_balance_context_values BCV

2853: loop
2854: fetch albc bulk collect into lat_bal_list limit 100000;
2855:
2856: forall i in 1..lat_bal_list.count
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

Line 3024: delete from pay_balance_context_values BCV

3020: if g_debug then
3021: hr_utility.set_location('hrassact.del_latest_balances',20);
3022: end if;
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;

Line 3037: delete from pay_balance_context_values BCV

3033: if g_debug then
3034: hr_utility.set_location('hrassact.del_latest_balances',40);
3035: end if;
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;

Line 3081: delete from pay_balance_context_values BCV

3077: if g_debug then
3078: hr_utility.set_location('hrassact.del_latest_balances',70);
3079: end if;
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;

Line 3095: delete from pay_balance_context_values BCV

3091: if g_debug then
3092: hr_utility.set_location('hrassact.del_latest_balances',80);
3093: end if;
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;

Line 7351: from pay_balance_context_values

7347: --
7348: cursor balance_context_values is
7349: select context_id,
7350: value
7351: from pay_balance_context_values
7352: where latest_balance_id = p_lat_bal_id;
7353:
7354: c_indent constant varchar2(35) := 'hrassact.context_match_check';
7355: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;

Line 7523: delete from pay_balance_context_values

7519: hr_utility.set_location (c_indent, 30);
7520: end if;
7521:
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;

Line 7529: delete from pay_balance_context_values

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;
7531:
7532: delete from pay_person_latest_balances
7533: where latest_balance_id = lat_bal_id;