APPS.PY_ROLLBACK_PKG dependencies on PAY_BALANCE_CONTEXT_VALUES

Line 770: delete from pay_balance_context_values bcv

766: if bplbrec.prev_balance_value=-9999
767: or bplbrec.prev_balance_value is NULL
768: or bplbrec.prev_assignment_action_id is NULL
769: then
770: delete from pay_balance_context_values bcv
771: where bcv.latest_balance_id = bplbrec.latest_balance_id;
772:
773: delete from pay_person_latest_balances plb
774: where plb.latest_balance_id = bplbrec.latest_balance_id;

Line 793: delete from pay_balance_context_values bcv

789: where pay_person_latest_balances.latest_balance_id =
790: bplbrec.latest_balance_id;
791: end if;
792: else
793: delete from pay_balance_context_values bcv
794: where bcv.latest_balance_id = bplbrec.latest_balance_id;
795:
796: delete from pay_person_latest_balances plb
797: where plb.latest_balance_id = bplbrec.latest_balance_id;

Line 807: delete from pay_balance_context_values bcv

803: if balbrec.prev_balance_value=-9999
804: or balbrec.prev_balance_value is NULL
805: or balbrec.prev_assignment_action_id is NULL
806: then
807: delete from pay_balance_context_values bcv
808: where bcv.latest_balance_id = balbrec.latest_balance_id;
809:
810: delete from pay_assignment_latest_balances alb
811: where alb.latest_balance_id = balbrec.latest_balance_id;

Line 830: delete from pay_balance_context_values bcv

826: where pay_assignment_latest_balances.latest_balance_id =
827: balbrec.latest_balance_id;
828: end if;
829: else
830: delete from pay_balance_context_values bcv
831: where bcv.latest_balance_id = balbrec.latest_balance_id;
832:
833: delete from pay_assignment_latest_balances alb
834: where alb.latest_balance_id = balbrec.latest_balance_id;

Line 889: delete from pay_balance_context_values bcv

885: or calbrec.prev_balance_value is NULL
886: or calbrec.prev_assignment_action_id is NULL)
887: then
888: begin
889: delete from pay_balance_context_values bcv
890: where bcv.latest_balance_id = calbrec.latest_balance_id;
891: delete from pay_assignment_latest_balances alb
892: where alb.latest_balance_id=calbrec.latest_balance_id;
893: end;

Line 925: delete from pay_balance_context_values bcv

921: cplbrec.prev_balance_value is NULL or
922: cplbrec.prev_assignment_action_id is NULL)
923: then
924: begin
925: delete from pay_balance_context_values bcv
926: where bcv.latest_balance_id = cplbrec.latest_balance_id;
927: delete from pay_person_latest_balances plb
928: where plb.latest_balance_id=cplbrec.latest_balance_id;
929: end;