APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_FNDCPT_TX_EXTENSIONS

Line 848: -- Base table it is varchar2 IBY_FNDCPT_TX_EXTENSIONS

844:
845: l_pos NUMBER := 0;
846: l_retry_num NUMBER := 0;
847: --CC Reversal ER#16014135 Start
848: -- Base table it is varchar2 IBY_FNDCPT_TX_EXTENSIONS
849: --l_trxn_ref_number2 NUMBER;
850: l_trxn_ref_number2 VARCHAR2(50);
851: --CC Reversal ER#16014135 end
852:

Line 2546: iby_external_payers_all iepa, iby_fndcpt_tx_extensions ifte

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

Line 3064: FROM iby_fndcpt_tx_extensions

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)
3066: AND rownum<2;
3067: EXCEPTION
3068: WHEN NO_DATA_FOUND THEN

Line 3079: FROM iby_fndcpt_tx_extensions

3075: END IF;
3076: BEGIN
3077: SELECT nvl(VOICE_AUTHORIZATION_FLAG,'N')
3078: INTO l_voice_auth
3079: FROM iby_fndcpt_tx_extensions
3080: WHERE TRXN_EXTENSION_ID = l_trxn_extension_id;
3081: EXCEPTION WHEN NO_DATA_FOUND THEN
3082: l_voice_auth :='N';
3083: END;