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_RUN_BALANCE_BUILD dependencies on PAY_RUN_BALANCES

Line 429: delete /+ INDEX(prb PAY_RUN_BALANCES_N2) /

425: --
426: if (l_delete_bals) then
427: --
428: if l_rb_row_status in ('I','U','O') then
429: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */
430: from pay_run_balances prb
431: where prb.defined_balance_id = g_def_bal_id
432: and prb.assignment_action_id = p_asg_act_id;
433: end if;

Line 430: from pay_run_balances prb

426: if (l_delete_bals) then
427: --
428: if l_rb_row_status in ('I','U','O') then
429: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */
430: from pay_run_balances prb
431: where prb.defined_balance_id = g_def_bal_id
432: and prb.assignment_action_id = p_asg_act_id;
433: end if;
434: --

Line 539: delete /+ INDEX(prb PAY_RUN_BALANCES_N2) /

535: hr_utility.set_location(
536: 'pay_run_balance_build.calculate_full_asg_balances',30);
537: -- bug 11874880 reduce number of deletes by checking runbal row status
538: if (l_rb_row_status in ('I','U','O')) then
539: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */
540: from pay_run_balances prb
541: where prb.defined_balance_id = g_def_bal_id
542: and prb.assignment_action_id = p_asg_act_id;
543: end if;

Line 540: from pay_run_balances prb

536: 'pay_run_balance_build.calculate_full_asg_balances',30);
537: -- bug 11874880 reduce number of deletes by checking runbal row status
538: if (l_rb_row_status in ('I','U','O')) then
539: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */
540: from pay_run_balances prb
541: where prb.defined_balance_id = g_def_bal_id
542: and prb.assignment_action_id = p_asg_act_id;
543: end if;
544: --

Line 673: from pay_run_balances prb

669: end if;
670:
671: forall a in g_tab_def_bal.first..g_tab_def_bal.last
672: delete
673: from pay_run_balances prb
674: where prb.assignment_id = p_asg_id
675: and prb.defined_balance_id = g_tab_def_bal(a);
676: --
677: else

Line 686: -- delete from pay_run_balances

682: if ((g_program_name = 'RB_ADJD') and (g_old_balance_validation_tab.count > 0)
683: and (g_proc_mode <> 'SINGLE')) then --{
684: -- Oracle10 implementation restriction
685: -- forall old_bv in g_old_balance_validation_tab.first..g_old_balance_validation_tab.last
686: -- delete from pay_run_balances
687: -- where defined_balance_id = g_old_balance_validation_tab(old_bv).defined_balance_id
688: -- and effective_date < g_old_balance_validation_tab(old_bv).del_bal_before
689: -- and assignment_id = p_asg_id;
690: for old_bv in g_old_balance_validation_tab.first..g_old_balance_validation_tab.last loop

Line 691: delete from pay_run_balances

687: -- where defined_balance_id = g_old_balance_validation_tab(old_bv).defined_balance_id
688: -- and effective_date < g_old_balance_validation_tab(old_bv).del_bal_before
689: -- and assignment_id = p_asg_id;
690: for old_bv in g_old_balance_validation_tab.first..g_old_balance_validation_tab.last loop
691: delete from pay_run_balances
692: where defined_balance_id = g_old_balance_validation_tab(old_bv).defined_balance_id
693: and effective_date < g_old_balance_validation_tab(old_bv).del_bal_before
694: and assignment_id = p_asg_id;
695: end loop;

Line 705: delete /+ INDEX(prb PAY_RUN_BALANCES_N1) /

701: else
702: -- We must be regenerating all balances
703: --
704: if not g_purge_only then --{ not purge only so rb delete not by load date
705: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
706: from pay_run_balances prb
707: where prb.assignment_id = p_asg_id;
708: if g_debug then
709: hr_utility.trace('process_asg_lvl_balances. Delete rbs by asg . p_asg_id:'||p_asg_id||

Line 706: from pay_run_balances prb

702: -- We must be regenerating all balances
703: --
704: if not g_purge_only then --{ not purge only so rb delete not by load date
705: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
706: from pay_run_balances prb
707: where prb.assignment_id = p_asg_id;
708: if g_debug then
709: hr_utility.trace('process_asg_lvl_balances. Delete rbs by asg . p_asg_id:'||p_asg_id||
710: ' cnt:'||sql%rowcount);

Line 717: delete /+ INDEX(prb PAY_RUN_BALANCES_N1) /

713: end if; --}
714: --
715: else
716: --
717: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
718: from pay_run_balances prb
719: where prb.assignment_id = p_asg_id
720: and exists (select ''
721: from pay_balance_validation pbv

Line 718: from pay_run_balances prb

714: --
715: else
716: --
717: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
718: from pay_run_balances prb
719: where prb.assignment_id = p_asg_id
720: and exists (select ''
721: from pay_balance_validation pbv
722: where pbv.defined_balance_id = prb.defined_balance_id

Line 761: delete from pay_run_balances where assignment_id = p_asg_id and

757: end;
758: end if;
759: --
760: -- bug 11874880 delete run balances prior to load date
761: delete from pay_run_balances where assignment_id = p_asg_id and
762: effective_date < l_bal_load_date
763: and defined_balance_id = g_def_bal_id;
764: if g_debug then
765: hr_utility.trace('pay_run_balance_build.process_asg_lvl_balance delete rb rows before load date:' ||SQL%ROWCOUNT);

Line 886: delete from pay_run_balances

882: end if;
883: --
884: if (l_delete_bals) then
885: --
886: delete from pay_run_balances
887: where defined_balance_id = g_def_bal_id
888: and payroll_action_id = p_pactid;
889: --
890: else

Line 926: delete from pay_run_balances prb

922: if (l_delete_bals) then
923: --
924: if (g_proc_mode = 'INVALID') then
925: --
926: delete from pay_run_balances prb
927: where prb.payroll_action_id = p_pactid
928: and exists (select ''
929: from pay_balance_validation pbv
930: where pbv.defined_balance_id =

Line 940: delete from pay_run_balances

936: -- We must be regenerating all balances
937: --
938: if (g_load_type <> 'DELTA') and ( not g_purge_only ) then
939: --
940: delete from pay_run_balances
941: where payroll_action_id = p_pactid;
942: else
943: delete
944: from pay_run_balances prb

Line 944: from pay_run_balances prb

940: delete from pay_run_balances
941: where payroll_action_id = p_pactid;
942: else
943: delete
944: from pay_run_balances prb
945: where prb.payroll_action_id = p_pactid
946: and g_start_date is not null
947: and g_start_date > p_eff_date;
948: --

Line 1009: delete from pay_run_balances

1005: end if;
1006: --
1007: if (l_delete_bals) then
1008: --
1009: delete from pay_run_balances
1010: where defined_balance_id = g_def_bal_id
1011: and payroll_action_id = p_pactid;
1012: hr_utility.trace('calculate_full_grp_balances1. Delete by pact . p_pactid:'||p_pactid|| ' cnt:'||sql%rowcount);
1013: --

Line 1039: delete from pay_run_balances prb

1035: if (l_delete_bals) then
1036: --
1037: if (g_proc_mode = 'INVALID') then
1038: --
1039: delete from pay_run_balances prb
1040: where prb.payroll_action_id = p_pactid
1041: and exists (select ''
1042: from pay_balance_validation pbv
1043: where pbv.defined_balance_id = prb.defined_balance_id

Line 1052: delete from pay_run_balances

1048: --
1049: -- We must be regenerating all balances
1050: --
1051: if ( g_purge_only and g_start_date > p_eff_date ) or (not g_purge_only) then
1052: delete from pay_run_balances
1053: where payroll_action_id = p_pactid;
1054: hr_utility.trace('calculate_full_grp_balances3. Delete by pact . p_pactid:'||p_pactid|| ' cnt:'||sql%rowcount);
1055: end if;
1056: end if;

Line 1120: delete /+ INDEX(prb PAY_RUN_BALANCES_N4) /

1116: if (g_proc_mode <> 'SINGLE') then
1117: --
1118: if (g_proc_mode = 'INVALID') then
1119: --
1120: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
1121: from pay_run_balances prb
1122: where prb.payroll_action_id = p_pactid
1123: and exists (select /*+ INDEX(pbv PAY_BALANCE_VALIDATION_UK1) */ ''
1124: from pay_balance_validation pbv

Line 1121: from pay_run_balances prb

1117: --
1118: if (g_proc_mode = 'INVALID') then
1119: --
1120: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
1121: from pay_run_balances prb
1122: where prb.payroll_action_id = p_pactid
1123: and exists (select /*+ INDEX(pbv PAY_BALANCE_VALIDATION_UK1) */ ''
1124: from pay_balance_validation pbv
1125: where pbv.defined_balance_id = prb.defined_balance_id

Line 1143: delete /+ INDEX(prb PAY_RUN_BALANCES_N4) / from pay_run_balances prb

1139: if ((g_program_name = 'RB_ADJD') and (g_old_balance_validation_tab.count > 0)
1140: and (g_proc_mode <> 'SINGLE')) then --{
1141: l_del_cnt := 0;
1142: for old_bv in g_old_balance_validation_tab.first..g_old_balance_validation_tab.last loop
1143: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */ from pay_run_balances prb
1144: where prb.defined_balance_id = g_old_balance_validation_tab(old_bv).defined_balance_id
1145: and prb.effective_date < g_old_balance_validation_tab(old_bv).del_bal_before
1146: and prb.payroll_action_id = p_pactid;
1147: l_del_cnt := l_del_cnt + sql%rowcount;

Line 1157: delete /+ INDEX(prb PAY_RUN_BALANCES_N4) /

1153: ' cnt:'||l_del_cnt);
1154: end if;
1155: else
1156: --
1157: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
1158: from pay_run_balances prb
1159: where prb.payroll_action_id = p_pactid;
1160: if g_debug then
1161: hr_utility.trace('process_group_lvl_balances3. Delete rbs by pact . p_pactid:'||p_pactid||

Line 1158: from pay_run_balances prb

1154: end if;
1155: else
1156: --
1157: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
1158: from pay_run_balances prb
1159: where prb.payroll_action_id = p_pactid;
1160: if g_debug then
1161: hr_utility.trace('process_group_lvl_balances3. Delete rbs by pact . p_pactid:'||p_pactid||
1162: ' cnt:'||sql%rowcount);

Line 1168: delete /+ INDEX(prb PAY_RUN_BALANCES_N4) /

1164: end if;
1165: --
1166: else
1167: --
1168: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
1169: from pay_run_balances prb
1170: where prb.payroll_action_id = p_pactid
1171: and exists (select ''
1172: from pay_balance_validation pbv

Line 1169: from pay_run_balances prb

1165: --
1166: else
1167: --
1168: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
1169: from pay_run_balances prb
1170: where prb.payroll_action_id = p_pactid
1171: and exists (select ''
1172: from pay_balance_validation pbv
1173: where pbv.defined_balance_id = prb.defined_balance_id