APPS.IBY_DISBURSE_SINGLE_PMT_PKG dependencies on IBY_PAYMENT_REFERENCES

Line 2771: * the IBY_PAYMENT_REFERENCES table.

2767: print_debuginfo(l_module_name, 'ENTER');
2768:
2769: /*
2770: * Select the payment reference information from
2771: * the IBY_PAYMENT_REFERENCES table.
2772: */
2773: SELECT
2774: NVL(last_used_ref_number, -1)
2775: INTO

Line 2778: IBY_PAYMENT_REFERENCES

2774: NVL(last_used_ref_number, -1)
2775: INTO
2776: l_last_used_ref_num
2777: FROM
2778: IBY_PAYMENT_REFERENCES
2779: FOR UPDATE
2780: ;
2781:
2782: IF (l_last_used_ref_num = -1) THEN

Line 2807: IBY_PAYMENT_REFERENCES

2803: * other concurrent instances, now get the updated last
2804: * used ref number.
2805: */
2806: UPDATE
2807: IBY_PAYMENT_REFERENCES
2808: SET
2809: last_used_ref_number = l_anticipated_last_ref_num;
2810:
2811: /*