9909: for a payment in cash basis accounting setup */
9910: CURSOR c_get_pooled_flag(p_invoice_payment_id AP_INVOICE_PAYMENTS_ALL.INVOICE_PAYMENT_ID%TYPE) IS
9911: SELECT B.POOLED_FLAG
9912: FROM CE_BANK_ACCOUNTS B 9913: , AP_CHECKS_ALL C 9914: , AP_INVOICE_PAYMENTS_ALL A
9915: WHERE A.INVOICE_PAYMENT_ID = p_invoice_payment_id
9916: AND A.CHECK_ID = C.CHECK_ID
9917: AND C.CE_BANK_ACCT_USE_ID = B.BANK_ACCOUNT_ID;