DBA Data[Home] [Help]

APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_EXTN_AUTHORIZATIONS_V

Line 2305: IBY_EXTN_AUTHORIZATIONS_V IAUTH

2301: x_instrument_id,
2302: x_instrument_assignment_id
2303: FROM
2304: IBY_EXTN_INSTR_DETAILS_V ITEV,
2305: IBY_EXTN_AUTHORIZATIONS_V IAUTH
2306: WHERE
2307: itev.TRXN_EXTENSION_ID= IAUTH.TRXN_EXTENSION_ID (+) AND
2308: ITEV.TRXN_EXTENSION_ID = l_trxn_extension_id;
2309:

Line 2510: IBY_EXTN_AUTHORIZATIONS_V iauth,

2506: from iby_trxn_extensions_v where trxn_Extension_id=p_trxn_extension_id;*/
2507: select payment_channel_code,nvl(settled_flag,'N'),nvl(authorized_flag,'N')
2508: into l_payment_channel_code,l_settled_flag,l_authorized_flag -- bug 5194228
2509: from IBY_EXTN_INSTR_DETAILS_V itev ,
2510: IBY_EXTN_AUTHORIZATIONS_V iauth,
2511: IBY_EXTN_SETTLEMENTS_V iset
2512: where itev.trxn_extension_id=iauth.trxn_extension_id (+)
2513: and itev.trxn_extension_id=iset.trxn_extension_id (+)
2514: and itev.trxn_extension_id=p_trxn_extension_id;