APPS.IBY_PAYINSTR_PUB dependencies on IBY_PAYMENT_REFERENCES

Line 5801: * the IBY_PAYMENT_REFERENCES table.

5797: BEGIN
5798:
5799: /*
5800: * Select the payment reference information from
5801: * the IBY_PAYMENT_REFERENCES table.
5802: */
5803: SELECT
5804: NVL(last_used_ref_number, -1)
5805: INTO

Line 5808: IBY_PAYMENT_REFERENCES

5804: NVL(last_used_ref_number, -1)
5805: INTO
5806: l_last_used_ref_num
5807: FROM
5808: IBY_PAYMENT_REFERENCES
5809: FOR UPDATE
5810: ;
5811:
5812: IF (l_last_used_ref_num = -1) THEN

Line 5841: IBY_PAYMENT_REFERENCES

5837: * concurrent instances, now get the updated last
5838: * used ref number.
5839: */
5840: UPDATE
5841: IBY_PAYMENT_REFERENCES
5842: SET
5843: last_used_ref_number = l_anticipated_last_ref_num
5844: ;
5845: