APPS.PY_ROLLBACK_PKG dependencies on PAY_BALANCE_CONTEXT_VALUES

Line 765: delete from pay_balance_context_values bcv

761: if bplbrec.prev_balance_value=-9999
762: or bplbrec.prev_balance_value is NULL
763: or bplbrec.prev_assignment_action_id is NULL
764: then
765: delete from pay_balance_context_values bcv
766: where bcv.latest_balance_id = bplbrec.latest_balance_id;
767:
768: delete from pay_person_latest_balances plb
769: where plb.latest_balance_id = bplbrec.latest_balance_id;

Line 788: delete from pay_balance_context_values bcv

784: where pay_person_latest_balances.latest_balance_id =
785: bplbrec.latest_balance_id;
786: end if;
787: else
788: delete from pay_balance_context_values bcv
789: where bcv.latest_balance_id = bplbrec.latest_balance_id;
790:
791: delete from pay_person_latest_balances plb
792: where plb.latest_balance_id = bplbrec.latest_balance_id;

Line 802: delete from pay_balance_context_values bcv

798: if balbrec.prev_balance_value=-9999
799: or balbrec.prev_balance_value is NULL
800: or balbrec.prev_assignment_action_id is NULL
801: then
802: delete from pay_balance_context_values bcv
803: where bcv.latest_balance_id = balbrec.latest_balance_id;
804:
805: delete from pay_assignment_latest_balances alb
806: where alb.latest_balance_id = balbrec.latest_balance_id;

Line 825: delete from pay_balance_context_values bcv

821: where pay_assignment_latest_balances.latest_balance_id =
822: balbrec.latest_balance_id;
823: end if;
824: else
825: delete from pay_balance_context_values bcv
826: where bcv.latest_balance_id = balbrec.latest_balance_id;
827:
828: delete from pay_assignment_latest_balances alb
829: where alb.latest_balance_id = balbrec.latest_balance_id;

Line 884: delete from pay_balance_context_values bcv

880: or calbrec.prev_balance_value is NULL
881: or calbrec.prev_assignment_action_id is NULL)
882: then
883: begin
884: delete from pay_balance_context_values bcv
885: where bcv.latest_balance_id = calbrec.latest_balance_id;
886: delete from pay_assignment_latest_balances alb
887: where alb.latest_balance_id=calbrec.latest_balance_id;
888: end;

Line 920: delete from pay_balance_context_values bcv

916: cplbrec.prev_balance_value is NULL or
917: cplbrec.prev_assignment_action_id is NULL)
918: then
919: begin
920: delete from pay_balance_context_values bcv
921: where bcv.latest_balance_id = cplbrec.latest_balance_id;
922: delete from pay_person_latest_balances plb
923: where plb.latest_balance_id=cplbrec.latest_balance_id;
924: end;