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.

[Home] [Help]

APPS.PAY_RUN_BALANCE_BUILD dependencies on PAY_RUN_BALANCES

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

339: end if;
340: --
341: if (l_delete_bals) then
342: --
343: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */
344: from pay_run_balances prb
345: where prb.defined_balance_id = g_def_bal_id
346: and prb.assignment_action_id = p_asg_act_id;
347: --

Line 344: from pay_run_balances prb

340: --
341: if (l_delete_bals) then
342: --
343: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */
344: from pay_run_balances prb
345: where prb.defined_balance_id = g_def_bal_id
346: and prb.assignment_action_id = p_asg_act_id;
347: --
348: else

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

438: hr_utility.set_location(
439: 'pay_run_balance_build.calculate_full_asg_balances',30);
440:
441: --
442: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */
443: from pay_run_balances prb
444: where prb.defined_balance_id = g_def_bal_id
445: and prb.assignment_action_id = p_asg_act_id;
446: --

Line 443: from pay_run_balances prb

439: 'pay_run_balance_build.calculate_full_asg_balances',30);
440:
441: --
442: delete /*+ INDEX(prb PAY_RUN_BALANCES_N2) */
443: from pay_run_balances prb
444: where prb.defined_balance_id = g_def_bal_id
445: and prb.assignment_action_id = p_asg_act_id;
446: --
447: else

Line 548: delete /+ USE_NL(prb) INDEX(prb PAY_RUN_BALANCES_N1) /

544: --
545: -- altered delete statement to use pay_balance_attributes rather than
546: -- pay_balance_validation to identify rows to be deleted
547: --
548: delete /*+ USE_NL(prb) INDEX(prb PAY_RUN_BALANCES_N1) */
549: from pay_run_balances prb
550: where prb.assignment_id = p_asg_id
551: and prb.defined_balance_id in
552: (select pba.defined_balance_id

Line 549: from pay_run_balances prb

545: -- altered delete statement to use pay_balance_attributes rather than
546: -- pay_balance_validation to identify rows to be deleted
547: --
548: delete /*+ USE_NL(prb) INDEX(prb PAY_RUN_BALANCES_N1) */
549: from pay_run_balances prb
550: where prb.assignment_id = p_asg_id
551: and prb.defined_balance_id in
552: (select pba.defined_balance_id
553: from pay_balance_attributes pba

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

560: -- We must be regenerating all balances
561: --
562: if (g_load_type <> 'DELTA') then
563: --
564: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
565: from pay_run_balances prb
566: where prb.assignment_id = p_asg_id;
567: --
568: else

Line 565: from pay_run_balances prb

561: --
562: if (g_load_type <> 'DELTA') then
563: --
564: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
565: from pay_run_balances prb
566: where prb.assignment_id = p_asg_id;
567: --
568: else
569: --

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

566: where prb.assignment_id = p_asg_id;
567: --
568: else
569: --
570: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
571: from pay_run_balances prb
572: where prb.assignment_id = p_asg_id
573: and exists (select ''
574: from pay_balance_validation pbv

Line 571: from pay_run_balances prb

567: --
568: else
569: --
570: delete /*+ INDEX(prb PAY_RUN_BALANCES_N1) */
571: from pay_run_balances prb
572: where prb.assignment_id = p_asg_id
573: and exists (select ''
574: from pay_balance_validation pbv
575: where pbv.defined_balance_id = prb.defined_balance_id

Line 700: delete from pay_run_balances

696: end if;
697: --
698: if (l_delete_bals) then
699: --
700: delete from pay_run_balances
701: where defined_balance_id = g_def_bal_id
702: and payroll_action_id = p_pactid;
703: --
704: else

Line 740: delete from pay_run_balances prb

736: if (l_delete_bals) then
737: --
738: if (g_proc_mode = 'INVALID') then
739: --
740: delete from pay_run_balances prb
741: where prb.payroll_action_id = p_pactid
742: and exists (select ''
743: from pay_balance_validation pbv
744: where pbv.defined_balance_id =

Line 754: delete from pay_run_balances

750: -- We must be regenerating all balances
751: --
752: if (g_load_type <> 'DELTA') then
753: --
754: delete from pay_run_balances
755: where payroll_action_id = p_pactid;
756: else
757: delete
758: from pay_run_balances prb

Line 758: from pay_run_balances prb

754: delete from pay_run_balances
755: where payroll_action_id = p_pactid;
756: else
757: delete
758: from pay_run_balances prb
759: where prb.payroll_action_id = p_pactid
760: and g_start_date is not null
761: and g_start_date > p_eff_date;
762: --

Line 817: delete from pay_run_balances

813: end if;
814: --
815: if (l_delete_bals) then
816: --
817: delete from pay_run_balances
818: where defined_balance_id = g_def_bal_id
819: and payroll_action_id = p_pactid;
820: --
821: else

Line 844: delete from pay_run_balances prb

840: if (l_delete_bals) then
841: --
842: if (g_proc_mode = 'INVALID') then
843: --
844: delete from pay_run_balances prb
845: where prb.payroll_action_id = p_pactid
846: and exists (select ''
847: from pay_balance_validation pbv
848: where pbv.defined_balance_id = prb.defined_balance_id

Line 855: delete from pay_run_balances

851: else
852: --
853: -- We must be regenerating all balances
854: --
855: delete from pay_run_balances
856: where payroll_action_id = p_pactid;
857: end if;
858: --
859: else

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

907: if (g_proc_mode <> 'SINGLE') then
908: --
909: if (g_proc_mode = 'INVALID') then
910: --
911: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
912: from pay_run_balances prb
913: where prb.payroll_action_id = p_pactid
914: and exists (select /*+ INDEX(pbv PAY_BALANCE_VALIDATION_UK1) */ ''
915: from pay_balance_validation pbv

Line 912: from pay_run_balances prb

908: --
909: if (g_proc_mode = 'INVALID') then
910: --
911: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
912: from pay_run_balances prb
913: where prb.payroll_action_id = p_pactid
914: and exists (select /*+ INDEX(pbv PAY_BALANCE_VALIDATION_UK1) */ ''
915: from pay_balance_validation pbv
916: where pbv.defined_balance_id = prb.defined_balance_id

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

922: -- We must be regenerating all balances
923: --
924: if (g_load_type <> 'DELTA') then
925: --
926: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
927: from pay_run_balances prb
928: where prb.payroll_action_id = p_pactid;
929: --
930: else

Line 927: from pay_run_balances prb

923: --
924: if (g_load_type <> 'DELTA') then
925: --
926: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
927: from pay_run_balances prb
928: where prb.payroll_action_id = p_pactid;
929: --
930: else
931: --

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

928: where prb.payroll_action_id = p_pactid;
929: --
930: else
931: --
932: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
933: from pay_run_balances prb
934: where prb.payroll_action_id = p_pactid
935: and exists (select ''
936: from pay_balance_validation pbv

Line 933: from pay_run_balances prb

929: --
930: else
931: --
932: delete /*+ INDEX(prb PAY_RUN_BALANCES_N4) */
933: from pay_run_balances prb
934: where prb.payroll_action_id = p_pactid
935: and exists (select ''
936: from pay_balance_validation pbv
937: where pbv.defined_balance_id = prb.defined_balance_id