APPS.PY_ROLLBACK_PKG dependencies on PAY_LATEST_BALANCES

Line 675: from pay_latest_balances lb,

671: lb.prev_expiry_date,
672: lb.expired_value,
673: lb.expired_assignment_action_id,
674: lb.assignment_action_id
675: from pay_latest_balances lb,
676: pay_defined_balances pdb,
677: pay_balance_feeds_f pbf,
678: pay_run_result_values rrv,
679: pay_run_results prr

Line 722: from pay_latest_balances lb

718: lb.prev_assignment_action_id,
719: lb.prev_expiry_date,
720: lb.expired_value,
721: lb.expired_assignment_action_id
722: from pay_latest_balances lb
723: where lb.assignment_action_id = p_info.assact_id;
724: --
725: l_person_id per_all_assignments_f.person_id%TYPE;
726:

Line 841: delete from pay_latest_balances lb

837: if blbrec.prev_balance_value=-9999
838: or blbrec.prev_balance_value is NULL
839: or blbrec.prev_assignment_action_id is NULL
840: then
841: delete from pay_latest_balances lb
842: where lb.latest_balance_id = blbrec.latest_balance_id;
843: else
844: if blbrec.prev_assignment_action_id = blbrec.expired_assignment_action_id
845: then

Line 846: update pay_latest_balances

842: where lb.latest_balance_id = blbrec.latest_balance_id;
843: else
844: if blbrec.prev_assignment_action_id = blbrec.expired_assignment_action_id
845: then
846: update pay_latest_balances
847: set expired_assignment_action_id = -9999,
848: expired_value = -9999,
849: expired_date = null
850: where pay_latest_balances.latest_balance_id =

Line 850: where pay_latest_balances.latest_balance_id =

846: update pay_latest_balances
847: set expired_assignment_action_id = -9999,
848: expired_value = -9999,
849: expired_date = null
850: where pay_latest_balances.latest_balance_id =
851: blbrec.latest_balance_id;
852: end if;
853: update pay_latest_balances
854: set assignment_action_id = blbrec.prev_assignment_action_id,

Line 853: update pay_latest_balances

849: expired_date = null
850: where pay_latest_balances.latest_balance_id =
851: blbrec.latest_balance_id;
852: end if;
853: update pay_latest_balances
854: set assignment_action_id = blbrec.prev_assignment_action_id,
855: value = blbrec.prev_balance_value,
856: expiry_date = blbrec.prev_expiry_date,
857: prev_assignment_action_id = -9999,

Line 860: where pay_latest_balances.latest_balance_id =

856: expiry_date = blbrec.prev_expiry_date,
857: prev_assignment_action_id = -9999,
858: prev_balance_value = -9999,
859: prev_expiry_date = null
860: where pay_latest_balances.latest_balance_id =
861: blbrec.latest_balance_id;
862: end if;
863: else
864: delete from pay_latest_balances alb

Line 864: delete from pay_latest_balances alb

860: where pay_latest_balances.latest_balance_id =
861: blbrec.latest_balance_id;
862: end if;
863: else
864: delete from pay_latest_balances alb
865: where alb.latest_balance_id = blbrec.latest_balance_id;
866: end if;
867: end loop;
868:

Line 954: delete from pay_latest_balances lb

950: or clbrec.prev_balance_value is NULL
951: or clbrec.prev_assignment_action_id is NULL)
952: then
953: begin
954: delete from pay_latest_balances lb
955: where lb.latest_balance_id=clbrec.latest_balance_id;
956: end;
957: else
958: begin

Line 961: update pay_latest_balances

957: else
958: begin
959: if clbrec.prev_assignment_action_id=clbrec.expired_assignment_action_id
960: then
961: update pay_latest_balances
962: set expired_assignment_action_id=-9999,
963: expired_value=-9999,
964: expired_date = null
965: where pay_latest_balances.latest_balance_id =

Line 965: where pay_latest_balances.latest_balance_id =

961: update pay_latest_balances
962: set expired_assignment_action_id=-9999,
963: expired_value=-9999,
964: expired_date = null
965: where pay_latest_balances.latest_balance_id =
966: clbrec.latest_balance_id;
967: end if;
968: update pay_latest_balances
969: set assignment_action_id=clbrec.prev_assignment_action_id,

Line 968: update pay_latest_balances

964: expired_date = null
965: where pay_latest_balances.latest_balance_id =
966: clbrec.latest_balance_id;
967: end if;
968: update pay_latest_balances
969: set assignment_action_id=clbrec.prev_assignment_action_id,
970: value=clbrec.prev_balance_value,
971: expiry_date = clbrec.prev_expiry_date,
972: prev_assignment_action_id=-9999,

Line 975: where pay_latest_balances.latest_balance_id =

971: expiry_date = clbrec.prev_expiry_date,
972: prev_assignment_action_id=-9999,
973: prev_balance_value=-9999,
974: prev_expiry_date = null
975: where pay_latest_balances.latest_balance_id =
976: clbrec.latest_balance_id;
977: end;
978: end if;
979: end loop;