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.PAY_BALANCE_FEED_DEL_PKG dependencies on PAY_BALANCE_CONTEXT_VALUES

Line 321: delete from pay_balance_context_values BCV

317: end if;
318: -- Delete all balance context values and
319: -- person latest balances.
320: for plbcrec in platbalc loop
321: delete from pay_balance_context_values BCV
322: where BCV.latest_balance_id = plbcrec.latest_balance_id;
323: --
324: delete from pay_person_latest_balances PLB
325: where PLB.latest_balance_id = plbcrec.latest_balance_id;

Line 337: delete from pay_balance_context_values BCV

333:
334: --Commented the following and added a block with cusrsor and bulk delete
335: --for Bug:6595092
336: /* for albcrec in alatbalc loop
337: delete from pay_balance_context_values BCV
338: where BCV.latest_balance_id = albcrec.latest_balance_id;
339: --
340: delete from pay_assignment_latest_balances ALB
341: where ALB.latest_balance_id = albcrec.latest_balance_id;

Line 386: delete from pay_balance_context_values BCV

382: end if;
383: close ivchk;
384: end if;
385: if l_rrv_found = 1 then
386: delete from pay_balance_context_values BCV
387: where BCV.latest_balance_id = plbcrec.latest_balance_id;
388: --
389: delete from pay_person_latest_balances PLB
390: where PLB.latest_balance_id = plbcrec.latest_balance_id;

Line 455: delete from pay_balance_context_values BCV

451: end if;
452: -- Delete all balance context values and
453: -- person latest balances.
454: for plbcrec in plbc loop
455: delete from pay_balance_context_values BCV
456: where BCV.latest_balance_id = plbcrec.latest_balance_id;
457: --
458: delete from pay_person_latest_balances PLB
459: where PLB.latest_balance_id = plbcrec.latest_balance_id;

Line 497: delete from pay_balance_context_values BCV

493: if g_debug then
494: hr_utility.set_location(lv_proc_name,100);
495: end if;
496:
497: delete from pay_balance_context_values BCV
498: where BCV.latest_balance_id = plrec.latest_balance_id;
499: --
500: if (plrec.balance_type = 'P') then
501: delete from pay_person_latest_balances PLB

Line 1012: delete from pay_balance_context_values BCV

1008: loop
1009: fetch alatbalc bulk collect into lat_bal_list limit 10000;
1010:
1011: forall i in 1..lat_bal_list.count
1012: delete from pay_balance_context_values BCV
1013: where BCV.latest_balance_id = lat_bal_list(i);
1014:
1015: forall i in 1..lat_bal_list.count
1016: delete from pay_assignment_latest_balances ALB

Line 1032: delete from pay_balance_context_values BCV

1028: loop
1029: fetch albc bulk collect into lat_bal_list limit 10000;
1030:
1031: forall i in 1..lat_bal_list.count
1032: delete from pay_balance_context_values BCV
1033: where BCV.latest_balance_id = lat_bal_list(i);
1034:
1035: forall i in 1..lat_bal_list.count
1036: delete from pay_assignment_latest_balances ALB

Line 1055: delete from pay_balance_context_values bcv

1051: loop
1052: fetch pl_feed_chk_a bulk collect into lat_bal_list limit 10000;
1053:
1054: forall i in 1..lat_bal_list.count
1055: delete from pay_balance_context_values bcv
1056: where bcv.latest_balance_id = lat_bal_list(i);
1057:
1058: forall i in 1..lat_bal_list.count
1059: delete from pay_assignment_latest_balances alb