APPS.PY_ROLLBACK_PKG dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 656: from pay_assignment_latest_balances alb,

652: alb.prev_assignment_action_id,
653: alb.expired_value,
654: alb.expired_assignment_action_id,
655: alb.assignment_action_id
656: from pay_assignment_latest_balances alb,
657: pay_defined_balances pdb,
658: pay_balance_feeds_f pbf,
659: pay_run_result_values rrv,
660: pay_run_results prr

Line 717: from pay_assignment_latest_balances alb

713: alb.prev_balance_value,
714: alb.prev_assignment_action_id,
715: alb.expired_value,
716: alb.expired_assignment_action_id
717: from pay_assignment_latest_balances alb
718: where alb.assignment_action_id = p_info.assact_id;
719: --
720: cursor clb is
721: select lb.latest_balance_id,

Line 810: delete from pay_assignment_latest_balances alb

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;
812: else
813: if balbrec.prev_assignment_action_id = balbrec.expired_assignment_action_id
814: then

Line 815: update pay_assignment_latest_balances

811: where alb.latest_balance_id = balbrec.latest_balance_id;
812: else
813: if balbrec.prev_assignment_action_id = balbrec.expired_assignment_action_id
814: then
815: update pay_assignment_latest_balances
816: set expired_assignment_action_id = -9999,
817: expired_value = -9999
818: where pay_assignment_latest_balances.latest_balance_id =
819: balbrec.latest_balance_id;

Line 818: where pay_assignment_latest_balances.latest_balance_id =

814: then
815: update pay_assignment_latest_balances
816: set expired_assignment_action_id = -9999,
817: expired_value = -9999
818: where pay_assignment_latest_balances.latest_balance_id =
819: balbrec.latest_balance_id;
820: end if;
821: update pay_assignment_latest_balances
822: set assignment_action_id = balbrec.prev_assignment_action_id,

Line 821: update pay_assignment_latest_balances

817: expired_value = -9999
818: where pay_assignment_latest_balances.latest_balance_id =
819: balbrec.latest_balance_id;
820: end if;
821: update pay_assignment_latest_balances
822: set assignment_action_id = balbrec.prev_assignment_action_id,
823: value = balbrec.prev_balance_value,
824: prev_assignment_action_id = -9999,
825: prev_balance_value = -9999

Line 826: where pay_assignment_latest_balances.latest_balance_id =

822: set assignment_action_id = balbrec.prev_assignment_action_id,
823: value = balbrec.prev_balance_value,
824: prev_assignment_action_id = -9999,
825: prev_balance_value = -9999
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

Line 833: delete from pay_assignment_latest_balances alb

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;
835: end if;
836: end loop;
837:

Line 891: delete from pay_assignment_latest_balances alb

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;
894: else
895: begin

Line 898: update pay_assignment_latest_balances

894: else
895: begin
896: if calbrec.prev_assignment_action_id=calbrec.expired_assignment_action_id
897: then
898: update pay_assignment_latest_balances
899: set expired_assignment_action_id=-9999,
900: expired_value=-9999
901: where pay_assignment_latest_balances.latest_balance_id =
902: calbrec.latest_balance_id;

Line 901: where pay_assignment_latest_balances.latest_balance_id =

897: then
898: update pay_assignment_latest_balances
899: set expired_assignment_action_id=-9999,
900: expired_value=-9999
901: where pay_assignment_latest_balances.latest_balance_id =
902: calbrec.latest_balance_id;
903: end if;
904: update pay_assignment_latest_balances
905: set assignment_action_id=calbrec.prev_assignment_action_id,

Line 904: update pay_assignment_latest_balances

900: expired_value=-9999
901: where pay_assignment_latest_balances.latest_balance_id =
902: calbrec.latest_balance_id;
903: end if;
904: update pay_assignment_latest_balances
905: set assignment_action_id=calbrec.prev_assignment_action_id,
906: value=calbrec.prev_balance_value,
907: prev_assignment_action_id=-9999,
908: prev_balance_value=-9999

Line 909: where pay_assignment_latest_balances.latest_balance_id =

905: set assignment_action_id=calbrec.prev_assignment_action_id,
906: value=calbrec.prev_balance_value,
907: prev_assignment_action_id=-9999,
908: prev_balance_value=-9999
909: where pay_assignment_latest_balances.latest_balance_id =
910: calbrec.latest_balance_id;
911: end;
912: end if;
913: end loop;