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 539: pay_balance_context_values

535: Delete pre_payment rows for
536: QuickPay Pre-Payment process.
537: 25-NOV-1994 DSAXBY 40.22 Change in params to qpassact.
538: 26-OCT-1994 DSAXBY 40.21 Delete from the
539: pay_balance_context_values
540: table where necessary.
541: Set time_period_id for
542: balance adjustments.
543: Created public versions of

Line 1638: delete from pay_balance_context_values VAL

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

Line 1654: delete from pay_balance_context_values VAL

1650: --
1651: if g_debug then
1652: hr_utility.set_location('hrassact.do_assact_rollback',35);
1653: end if;
1654: delete from pay_balance_context_values VAL
1655: where exists (
1656: select null
1657: from pay_assignment_latest_balances ALB
1658: where ALB.assignment_action_id = p_assact_rec.assact_id

Line 2554: delete from pay_balance_context_values BCV

2550: end if;
2551: -- Delete all balance context values and
2552: -- person latest balances.
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;

Line 2570: delete from pay_balance_context_values BCV

2566:
2567: --Commented the following and added a block with cusrsor and bulk delete
2568: --for Bug:6595092
2569: /* for albcrec in alatbalc loop
2570: delete from pay_balance_context_values BCV
2571: where BCV.latest_balance_id = albcrec.latest_balance_id;
2572: --
2573: delete from pay_assignment_latest_balances ALB
2574: where ALB.latest_balance_id = albcrec.latest_balance_id;

Line 2582: delete from pay_balance_context_values BCV

2578: loop
2579: fetch alatbalc bulk collect into lat_bal_list limit 100000;
2580:
2581: forall i in 1..lat_bal_list.count
2582: delete from pay_balance_context_values BCV
2583: where BCV.latest_balance_id = lat_bal_list(i);
2584:
2585: forall i in 1..lat_bal_list.count
2586: delete from pay_assignment_latest_balances ALB

Line 2633: delete from pay_balance_context_values BCV

2629: end if;
2630: close ivchk;
2631: end if;
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;

Line 2664: delete from pay_balance_context_values BCV

2660: end if;
2661: close ivchk;
2662: end if;
2663: if l_rrv_found = 1 then
2664: delete from pay_balance_context_values BCV
2665: where BCV.latest_balance_id = albcrec.latest_balance_id;
2666: --
2667: delete from pay_assignment_latest_balances ALB
2668: where ALB.latest_balance_id = albcrec.latest_balance_id;

Line 2706: delete from pay_balance_context_values BCV

2702: end if;
2703: -- Delete all balance context values and
2704: -- person latest balances.
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;

Line 2723: delete from pay_balance_context_values BCV

2719: loop
2720: fetch albc bulk collect into lat_bal_list limit 100000;
2721:
2722: forall i in 1..lat_bal_list.count
2723: delete from pay_balance_context_values BCV
2724: where BCV.latest_balance_id = lat_bal_list(i);
2725:
2726: forall i in 1..lat_bal_list.count
2727: delete from pay_assignment_latest_balances ALB

Line 2759: delete from pay_balance_context_values BCV

2755: if g_debug then
2756: hr_utility.set_location('hrassact.trash_latest_balances',100);
2757: end if;
2758:
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

Line 2778: delete from pay_balance_context_values BCV

2774: loop
2775: fetch pl_feed_chk_a bulk collect into lat_bal_list limit 100000;
2776:
2777: forall i in 1..lat_bal_list.count
2778: delete from pay_balance_context_values BCV
2779: where BCV.latest_balance_id = lat_bal_list(i);
2780:
2781: forall i in 1..lat_bal_list.count
2782: delete from pay_assignment_latest_balances ALB

Line 2859: delete from pay_balance_context_values BCV

2855: --
2856: -- Delete all balance context values and
2857: -- person latest balances.
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;

Line 2874: delete from pay_balance_context_values BCV

2870: loop
2871: fetch albc bulk collect into lat_bal_list limit 100000;
2872:
2873: forall i in 1..lat_bal_list.count
2874: delete from pay_balance_context_values BCV
2875: where BCV.latest_balance_id = lat_bal_list(i);
2876:
2877: forall i in 1..lat_bal_list.count
2878: delete from pay_assignment_latest_balances ALB

Line 3041: delete from pay_balance_context_values BCV

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

Line 3054: delete from pay_balance_context_values BCV

3050: if g_debug then
3051: hr_utility.set_location('hrassact.del_latest_balances',40);
3052: end if;
3053: for albcrec in albc(l_person_id) loop
3054: delete from pay_balance_context_values BCV
3055: where BCV.latest_balance_id = albcrec.latest_balance_id;
3056: --
3057: delete from pay_assignment_latest_balances ALB
3058: where ALB.latest_balance_id = albcrec.latest_balance_id;

Line 3098: delete from pay_balance_context_values BCV

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

Line 3112: delete from pay_balance_context_values BCV

3108: if g_debug then
3109: hr_utility.set_location('hrassact.del_latest_balances',80);
3110: end if;
3111: for albcrec in albc_selective(l_person_id, l_element_type_id) loop
3112: delete from pay_balance_context_values BCV
3113: where BCV.latest_balance_id = albcrec.latest_balance_id;
3114: --
3115: delete from pay_assignment_latest_balances ALB
3116: where ALB.latest_balance_id = albcrec.latest_balance_id;

Line 7616: from pay_balance_context_values

7612: --
7613: cursor balance_context_values is
7614: select context_id,
7615: value
7616: from pay_balance_context_values
7617: where latest_balance_id = p_lat_bal_id;
7618:
7619: c_indent constant varchar2(35) := 'hrassact.context_match_check';
7620: l_jurisdiction_level pay_balance_types.jurisdiction_level%TYPE;

Line 7788: delete from pay_balance_context_values

7784: hr_utility.set_location (c_indent, 30);
7785: end if;
7786:
7787: if lat_bal_type = 'A' then
7788: delete from pay_balance_context_values
7789: where latest_balance_id = lat_bal_id;
7790:
7791: delete from pay_assignment_latest_balances
7792: where latest_balance_id = lat_bal_id;

Line 7794: delete from pay_balance_context_values

7790:
7791: delete from pay_assignment_latest_balances
7792: where latest_balance_id = lat_bal_id;
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;