APPS.PY_ROLLBACK_PKG dependencies on PAY_LATEST_BALANCES

Line 680: from pay_latest_balances lb,

676: lb.prev_expiry_date,
677: lb.expired_value,
678: lb.expired_assignment_action_id,
679: lb.assignment_action_id
680: from pay_latest_balances lb,
681: pay_defined_balances pdb,
682: pay_balance_feeds_f pbf,
683: pay_run_result_values rrv,
684: pay_run_results prr

Line 727: from pay_latest_balances lb

723: lb.prev_assignment_action_id,
724: lb.prev_expiry_date,
725: lb.expired_value,
726: lb.expired_assignment_action_id
727: from pay_latest_balances lb
728: where lb.assignment_action_id = p_info.assact_id;
729: --
730: l_person_id per_all_assignments_f.person_id%TYPE;
731:

Line 846: delete from pay_latest_balances lb

842: if blbrec.prev_balance_value=-9999
843: or blbrec.prev_balance_value is NULL
844: or blbrec.prev_assignment_action_id is NULL
845: then
846: delete from pay_latest_balances lb
847: where lb.latest_balance_id = blbrec.latest_balance_id;
848: else
849: if blbrec.prev_assignment_action_id = blbrec.expired_assignment_action_id
850: then

Line 851: update pay_latest_balances

847: where lb.latest_balance_id = blbrec.latest_balance_id;
848: else
849: if blbrec.prev_assignment_action_id = blbrec.expired_assignment_action_id
850: then
851: update pay_latest_balances
852: set expired_assignment_action_id = -9999,
853: expired_value = -9999,
854: expired_date = null
855: where pay_latest_balances.latest_balance_id =

Line 855: where pay_latest_balances.latest_balance_id =

851: update pay_latest_balances
852: set expired_assignment_action_id = -9999,
853: expired_value = -9999,
854: expired_date = null
855: where pay_latest_balances.latest_balance_id =
856: blbrec.latest_balance_id;
857: end if;
858: update pay_latest_balances
859: set assignment_action_id = blbrec.prev_assignment_action_id,

Line 858: update pay_latest_balances

854: expired_date = null
855: where pay_latest_balances.latest_balance_id =
856: blbrec.latest_balance_id;
857: end if;
858: update pay_latest_balances
859: set assignment_action_id = blbrec.prev_assignment_action_id,
860: value = blbrec.prev_balance_value,
861: expiry_date = blbrec.prev_expiry_date,
862: prev_assignment_action_id = -9999,

Line 865: where pay_latest_balances.latest_balance_id =

861: expiry_date = blbrec.prev_expiry_date,
862: prev_assignment_action_id = -9999,
863: prev_balance_value = -9999,
864: prev_expiry_date = null
865: where pay_latest_balances.latest_balance_id =
866: blbrec.latest_balance_id;
867: end if;
868: else
869: delete from pay_latest_balances alb

Line 869: delete from pay_latest_balances alb

865: where pay_latest_balances.latest_balance_id =
866: blbrec.latest_balance_id;
867: end if;
868: else
869: delete from pay_latest_balances alb
870: where alb.latest_balance_id = blbrec.latest_balance_id;
871: end if;
872: end loop;
873:

Line 959: delete from pay_latest_balances lb

955: or clbrec.prev_balance_value is NULL
956: or clbrec.prev_assignment_action_id is NULL)
957: then
958: begin
959: delete from pay_latest_balances lb
960: where lb.latest_balance_id=clbrec.latest_balance_id;
961: end;
962: else
963: begin

Line 966: update pay_latest_balances

962: else
963: begin
964: if clbrec.prev_assignment_action_id=clbrec.expired_assignment_action_id
965: then
966: update pay_latest_balances
967: set expired_assignment_action_id=-9999,
968: expired_value=-9999,
969: expired_date = null
970: where pay_latest_balances.latest_balance_id =

Line 970: where pay_latest_balances.latest_balance_id =

966: update pay_latest_balances
967: set expired_assignment_action_id=-9999,
968: expired_value=-9999,
969: expired_date = null
970: where pay_latest_balances.latest_balance_id =
971: clbrec.latest_balance_id;
972: end if;
973: update pay_latest_balances
974: set assignment_action_id=clbrec.prev_assignment_action_id,

Line 973: update pay_latest_balances

969: expired_date = null
970: where pay_latest_balances.latest_balance_id =
971: clbrec.latest_balance_id;
972: end if;
973: update pay_latest_balances
974: set assignment_action_id=clbrec.prev_assignment_action_id,
975: value=clbrec.prev_balance_value,
976: expiry_date = clbrec.prev_expiry_date,
977: prev_assignment_action_id=-9999,

Line 980: where pay_latest_balances.latest_balance_id =

976: expiry_date = clbrec.prev_expiry_date,
977: prev_assignment_action_id=-9999,
978: prev_balance_value=-9999,
979: prev_expiry_date = null
980: where pay_latest_balances.latest_balance_id =
981: clbrec.latest_balance_id;
982: end;
983: end if;
984: end loop;