APPS.IBY_DISBURSE_SINGLE_PMT_PKG dependencies on IBY_PAYMENT_REFERENCES

Line 3052: * the IBY_PAYMENT_REFERENCES table.

3048:
3049: END IF;
3050: /*
3051: * Select the payment reference information from
3052: * the IBY_PAYMENT_REFERENCES table.
3053: */
3054: SELECT
3055: NVL(last_used_ref_number, -1)
3056: INTO

Line 3059: IBY_PAYMENT_REFERENCES

3055: NVL(last_used_ref_number, -1)
3056: INTO
3057: l_last_used_ref_num
3058: FROM
3059: IBY_PAYMENT_REFERENCES
3060: FOR UPDATE
3061: ;
3062:
3063: IF (l_last_used_ref_num = -1) THEN

Line 3090: IBY_PAYMENT_REFERENCES

3086: * other concurrent instances, now get the updated last
3087: * used ref number.
3088: */
3089: UPDATE
3090: IBY_PAYMENT_REFERENCES
3091: SET
3092: last_used_ref_number = l_anticipated_last_ref_num;
3093:
3094: /*