2542: IF l_debug_level > 0 THEN
2543: oe_debug_pub.add('Inside the ACH and Direct debit query for site use id...'||p_trxn_extension_id);
2544: END IF;
2545: select iepa.acct_site_use_id into l_site_use_id from
2546: iby_external_payers_all iepa, iby_fndcpt_tx_extensions ifte
2547: where iepa.ext_payer_id = ifte.ext_payer_id and
2548: ifte.trxn_extension_id = p_trxn_extension_id;
2549: END IF;
2550: IF l_debug_level > 0 THEN
3057: BEGIN
3058: SELECT ACCT_SITE_USE_ID
3059: INTO
3060: l_old_invoice_to_org_id
3061: FROM iby_external_payers_all
3062: WHERE ext_payer_id in
3063: (SELECT ext_payer_id
3064: FROM iby_fndcpt_tx_extensions
3065: WHERE trxn_extension_id =l_trxn_extension_id)