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 621: select /+ INDEX(plb PAY_PERSON_LATEST_BALANCES_N3)/

617: procedure remove_balances(p_info in rollback_rec) is
618: c_indent varchar2(40);
619: cursor baplb(l_person_id number) is
620: --
621: select /*+ INDEX(plb PAY_PERSON_LATEST_BALANCES_N3)*/
622: plb.latest_balance_id,
623: plb.prev_balance_value,
624: plb.prev_assignment_action_id,
625: plb.expired_value,

Line 628: from pay_person_latest_balances plb,

624: plb.prev_assignment_action_id,
625: plb.expired_value,
626: plb.expired_assignment_action_id,
627: plb.assignment_action_id
628: from pay_person_latest_balances plb,
629: pay_defined_balances pdb,
630: pay_balance_feeds_f pbf,
631: pay_run_result_values rrv,
632: pay_run_results prr

Line 703: from pay_person_latest_balances plb

699: plb.prev_balance_value,
700: plb.prev_assignment_action_id,
701: plb.expired_value,
702: plb.expired_assignment_action_id
703: from pay_person_latest_balances plb
704: where plb.assignment_action_id = p_info.assact_id;
705: --
706: cursor calb is
707: select alb.latest_balance_id,

Line 768: delete from pay_person_latest_balances plb

764: then
765: delete from pay_balance_context_values bcv
766: where bcv.latest_balance_id = bplbrec.latest_balance_id;
767:
768: delete from pay_person_latest_balances plb
769: where plb.latest_balance_id = bplbrec.latest_balance_id;
770: else
771: if bplbrec.prev_assignment_action_id = bplbrec.expired_assignment_action_id
772: then

Line 773: update pay_person_latest_balances

769: where plb.latest_balance_id = bplbrec.latest_balance_id;
770: else
771: if bplbrec.prev_assignment_action_id = bplbrec.expired_assignment_action_id
772: then
773: update pay_person_latest_balances
774: set expired_assignment_action_id = -9999,
775: expired_value = -9999
776: where pay_person_latest_balances.latest_balance_id =
777: bplbrec.latest_balance_id;

Line 776: where pay_person_latest_balances.latest_balance_id =

772: then
773: update pay_person_latest_balances
774: set expired_assignment_action_id = -9999,
775: expired_value = -9999
776: where pay_person_latest_balances.latest_balance_id =
777: bplbrec.latest_balance_id;
778: end if;
779: update pay_person_latest_balances
780: set assignment_action_id = bplbrec.prev_assignment_action_id,

Line 779: update pay_person_latest_balances

775: expired_value = -9999
776: where pay_person_latest_balances.latest_balance_id =
777: bplbrec.latest_balance_id;
778: end if;
779: update pay_person_latest_balances
780: set assignment_action_id = bplbrec.prev_assignment_action_id,
781: value = bplbrec.prev_balance_value,
782: prev_assignment_action_id = -9999,
783: prev_balance_value = -9999

Line 784: where pay_person_latest_balances.latest_balance_id =

780: set assignment_action_id = bplbrec.prev_assignment_action_id,
781: value = bplbrec.prev_balance_value,
782: prev_assignment_action_id = -9999,
783: prev_balance_value = -9999
784: where pay_person_latest_balances.latest_balance_id =
785: bplbrec.latest_balance_id;
786: end if;
787: else
788: delete from pay_balance_context_values bcv

Line 791: delete from pay_person_latest_balances plb

787: else
788: delete from pay_balance_context_values bcv
789: where bcv.latest_balance_id = bplbrec.latest_balance_id;
790:
791: delete from pay_person_latest_balances plb
792: where plb.latest_balance_id = bplbrec.latest_balance_id;
793: end if;
794: end loop;
795:

Line 922: delete from pay_person_latest_balances plb

918: then
919: begin
920: delete from pay_balance_context_values bcv
921: where bcv.latest_balance_id = cplbrec.latest_balance_id;
922: delete from pay_person_latest_balances plb
923: where plb.latest_balance_id=cplbrec.latest_balance_id;
924: end;
925: else
926: begin

Line 929: update pay_person_latest_balances

925: else
926: begin
927: if cplbrec.prev_assignment_action_id=cplbrec.expired_assignment_action_id
928: then
929: update pay_person_latest_balances
930: set expired_assignment_action_id=-9999,
931: expired_value=-9999
932: where pay_person_latest_balances.latest_balance_id =
933: cplbrec.latest_balance_id;

Line 932: where pay_person_latest_balances.latest_balance_id =

928: then
929: update pay_person_latest_balances
930: set expired_assignment_action_id=-9999,
931: expired_value=-9999
932: where pay_person_latest_balances.latest_balance_id =
933: cplbrec.latest_balance_id;
934: end if;
935: update pay_person_latest_balances
936: set assignment_action_id=cplbrec.prev_assignment_action_id,

Line 935: update pay_person_latest_balances

931: expired_value=-9999
932: where pay_person_latest_balances.latest_balance_id =
933: cplbrec.latest_balance_id;
934: end if;
935: update pay_person_latest_balances
936: set assignment_action_id=cplbrec.prev_assignment_action_id,
937: value=cplbrec.prev_balance_value,
938: prev_assignment_action_id=-9999,
939: prev_balance_value=-9999

Line 940: where pay_person_latest_balances.latest_balance_id =

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