eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_ROLLBACK_PKG dependencies on PAY_PERSON_LATEST_BALANCES

Line 626: select /+ INDEX(plb PAY_PERSON_LATEST_BALANCES_N3)/

622: procedure remove_balances(p_info in rollback_rec) is
623: c_indent varchar2(40);
624: cursor baplb(l_person_id number) is
625: --
626: select /*+ INDEX(plb PAY_PERSON_LATEST_BALANCES_N3)*/
627: plb.latest_balance_id,
628: plb.prev_balance_value,
629: plb.prev_assignment_action_id,
630: plb.expired_value,

Line 633: from pay_person_latest_balances plb,

629: plb.prev_assignment_action_id,
630: plb.expired_value,
631: plb.expired_assignment_action_id,
632: plb.assignment_action_id
633: from pay_person_latest_balances plb,
634: pay_defined_balances pdb,
635: pay_balance_feeds_f pbf,
636: pay_run_result_values rrv,
637: pay_run_results prr

Line 708: from pay_person_latest_balances plb

704: plb.prev_balance_value,
705: plb.prev_assignment_action_id,
706: plb.expired_value,
707: plb.expired_assignment_action_id
708: from pay_person_latest_balances plb
709: where plb.assignment_action_id = p_info.assact_id;
710: --
711: cursor calb is
712: select alb.latest_balance_id,

Line 773: delete from pay_person_latest_balances plb

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;
775: else
776: if bplbrec.prev_assignment_action_id = bplbrec.expired_assignment_action_id
777: then

Line 778: update pay_person_latest_balances

774: where plb.latest_balance_id = bplbrec.latest_balance_id;
775: else
776: if bplbrec.prev_assignment_action_id = bplbrec.expired_assignment_action_id
777: then
778: update pay_person_latest_balances
779: set expired_assignment_action_id = -9999,
780: expired_value = -9999
781: where pay_person_latest_balances.latest_balance_id =
782: bplbrec.latest_balance_id;

Line 781: where pay_person_latest_balances.latest_balance_id =

777: then
778: update pay_person_latest_balances
779: set expired_assignment_action_id = -9999,
780: expired_value = -9999
781: where pay_person_latest_balances.latest_balance_id =
782: bplbrec.latest_balance_id;
783: end if;
784: update pay_person_latest_balances
785: set assignment_action_id = bplbrec.prev_assignment_action_id,

Line 784: update pay_person_latest_balances

780: expired_value = -9999
781: where pay_person_latest_balances.latest_balance_id =
782: bplbrec.latest_balance_id;
783: end if;
784: update pay_person_latest_balances
785: set assignment_action_id = bplbrec.prev_assignment_action_id,
786: value = bplbrec.prev_balance_value,
787: prev_assignment_action_id = -9999,
788: prev_balance_value = -9999

Line 789: where pay_person_latest_balances.latest_balance_id =

785: set assignment_action_id = bplbrec.prev_assignment_action_id,
786: value = bplbrec.prev_balance_value,
787: prev_assignment_action_id = -9999,
788: prev_balance_value = -9999
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

Line 796: delete from pay_person_latest_balances plb

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;
798: end if;
799: end loop;
800:

Line 927: delete from pay_person_latest_balances plb

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;
930: else
931: begin

Line 934: update pay_person_latest_balances

930: else
931: begin
932: if cplbrec.prev_assignment_action_id=cplbrec.expired_assignment_action_id
933: then
934: update pay_person_latest_balances
935: set expired_assignment_action_id=-9999,
936: expired_value=-9999
937: where pay_person_latest_balances.latest_balance_id =
938: cplbrec.latest_balance_id;

Line 937: where pay_person_latest_balances.latest_balance_id =

933: then
934: update pay_person_latest_balances
935: set expired_assignment_action_id=-9999,
936: expired_value=-9999
937: where pay_person_latest_balances.latest_balance_id =
938: cplbrec.latest_balance_id;
939: end if;
940: update pay_person_latest_balances
941: set assignment_action_id=cplbrec.prev_assignment_action_id,

Line 940: update pay_person_latest_balances

936: expired_value=-9999
937: where pay_person_latest_balances.latest_balance_id =
938: cplbrec.latest_balance_id;
939: end if;
940: update pay_person_latest_balances
941: set assignment_action_id=cplbrec.prev_assignment_action_id,
942: value=cplbrec.prev_balance_value,
943: prev_assignment_action_id=-9999,
944: prev_balance_value=-9999

Line 945: where pay_person_latest_balances.latest_balance_id =

941: set assignment_action_id=cplbrec.prev_assignment_action_id,
942: value=cplbrec.prev_balance_value,
943: prev_assignment_action_id=-9999,
944: prev_balance_value=-9999
945: where pay_person_latest_balances.latest_balance_id =
946: cplbrec.latest_balance_id;
947: end;
948: end if;
949: end loop;