[Home] [Help]
3186: l_payer_ba XMLTYPE;
3187: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccount';
3188: CURSOR l_payer_ba_csr (p_bank_account_id IN NUMBER) IS
3189: SELECT int_bank_account
3190: FROM iby_xml_fd_prba_1_0_v
3191: WHERE bank_account_id = p_bank_account_id;
3192:
3193: BEGIN
3194: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3282: l_payer_ba XMLTYPE;
3283: l_Debug_Module VARCHAR2(255) := G_DEBUG_MODULE || '.Get_PayerBankAccount_Denorm';
3284: CURSOR l_payer_ba_csr (p_payment_id IN NUMBER) IS
3285: SELECT int_bank_account
3286: FROM iby_xml_fd_prba_1_0_v
3287: WHERE payment_id = p_payment_id;
3288:
3289: BEGIN
3290: