APPS.PY_ROLLBACK_PKG dependencies on PAY_ASSIGNMENT_LATEST_BALANCES

Line 651: from pay_assignment_latest_balances alb,

647: alb.prev_assignment_action_id,
648: alb.expired_value,
649: alb.expired_assignment_action_id,
650: alb.assignment_action_id
651: from pay_assignment_latest_balances alb,
652: pay_defined_balances pdb,
653: pay_balance_feeds_f pbf,
654: pay_run_result_values rrv,
655: pay_run_results prr

Line 712: from pay_assignment_latest_balances alb

708: alb.prev_balance_value,
709: alb.prev_assignment_action_id,
710: alb.expired_value,
711: alb.expired_assignment_action_id
712: from pay_assignment_latest_balances alb
713: where alb.assignment_action_id = p_info.assact_id;
714: --
715: cursor clb is
716: select lb.latest_balance_id,

Line 805: delete from pay_assignment_latest_balances alb

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;
807: else
808: if balbrec.prev_assignment_action_id = balbrec.expired_assignment_action_id
809: then

Line 810: update pay_assignment_latest_balances

806: where alb.latest_balance_id = balbrec.latest_balance_id;
807: else
808: if balbrec.prev_assignment_action_id = balbrec.expired_assignment_action_id
809: then
810: update pay_assignment_latest_balances
811: set expired_assignment_action_id = -9999,
812: expired_value = -9999
813: where pay_assignment_latest_balances.latest_balance_id =
814: balbrec.latest_balance_id;

Line 813: where pay_assignment_latest_balances.latest_balance_id =

809: then
810: update pay_assignment_latest_balances
811: set expired_assignment_action_id = -9999,
812: expired_value = -9999
813: where pay_assignment_latest_balances.latest_balance_id =
814: balbrec.latest_balance_id;
815: end if;
816: update pay_assignment_latest_balances
817: set assignment_action_id = balbrec.prev_assignment_action_id,

Line 816: update pay_assignment_latest_balances

812: expired_value = -9999
813: where pay_assignment_latest_balances.latest_balance_id =
814: balbrec.latest_balance_id;
815: end if;
816: update pay_assignment_latest_balances
817: set assignment_action_id = balbrec.prev_assignment_action_id,
818: value = balbrec.prev_balance_value,
819: prev_assignment_action_id = -9999,
820: prev_balance_value = -9999

Line 821: where pay_assignment_latest_balances.latest_balance_id =

817: set assignment_action_id = balbrec.prev_assignment_action_id,
818: value = balbrec.prev_balance_value,
819: prev_assignment_action_id = -9999,
820: prev_balance_value = -9999
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

Line 828: delete from pay_assignment_latest_balances alb

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;
830: end if;
831: end loop;
832:

Line 886: delete from pay_assignment_latest_balances alb

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;
889: else
890: begin

Line 893: update pay_assignment_latest_balances

889: else
890: begin
891: if calbrec.prev_assignment_action_id=calbrec.expired_assignment_action_id
892: then
893: update pay_assignment_latest_balances
894: set expired_assignment_action_id=-9999,
895: expired_value=-9999
896: where pay_assignment_latest_balances.latest_balance_id =
897: calbrec.latest_balance_id;

Line 896: where pay_assignment_latest_balances.latest_balance_id =

892: then
893: update pay_assignment_latest_balances
894: set expired_assignment_action_id=-9999,
895: expired_value=-9999
896: where pay_assignment_latest_balances.latest_balance_id =
897: calbrec.latest_balance_id;
898: end if;
899: update pay_assignment_latest_balances
900: set assignment_action_id=calbrec.prev_assignment_action_id,

Line 899: update pay_assignment_latest_balances

895: expired_value=-9999
896: where pay_assignment_latest_balances.latest_balance_id =
897: calbrec.latest_balance_id;
898: end if;
899: update pay_assignment_latest_balances
900: set assignment_action_id=calbrec.prev_assignment_action_id,
901: value=calbrec.prev_balance_value,
902: prev_assignment_action_id=-9999,
903: prev_balance_value=-9999

Line 904: where pay_assignment_latest_balances.latest_balance_id =

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