APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_EXTN_INSTR_DETAILS_V

Line 610: from IBY_EXTN_INSTR_DETAILS_V where trxn_extension_id = p_x_trxn_extension_id;

606: -- Based on the trxn extension id get the corresponding
607: -- assignment id from the payments table
608: -- bug 8586227
609: select instr_assignment_id into l_assign_id
610: from IBY_EXTN_INSTR_DETAILS_V where trxn_extension_id = p_x_trxn_extension_id;
611: IF l_debug_level > 0 THEN
612: oe_debug_pub.add('Instrument assignment id for existing instrument'||l_assign_id);
613: END IF;
614:

Line 1331: FROM IBY_EXTN_INSTR_DETAILS_V iextn,

1327: FROM iby_trxn_extensions_v
1328: WHERE trxn_extension_id = p_trxn_extension_id;*/
1329: SELECT nvl(settled_flag, 'N'),instrument_id,card_number
1330: INTO l_settled_flag,l_old_instrument_id,l_old_card_number
1331: FROM IBY_EXTN_INSTR_DETAILS_V iextn,
1332: IBY_EXTN_SETTLEMENTS_V iset
1333: WHERE
1334: iextn.trxn_extension_id= iset.trxn_extension_id (+) AND
1335: iextn.trxn_extension_id = p_trxn_extension_id;

Line 1506: from IBY_EXTN_INSTR_DETAILS_V

1502: BEGIN
1503: -- bug 8586227
1504: select trxn_ref_number2
1505: into l_trxn_ref_number2
1506: from IBY_EXTN_INSTR_DETAILS_V
1507: where trxn_extension_id = p_trxn_extension_id;
1508:
1509: EXCEPTION WHEN NO_DATA_FOUND THEN
1510: null;

Line 1962: from IBY_EXTN_INSTR_DETAILS_V

1958: Begin
1959: -- Bug 8586227
1960: select instrument_id, instrument_type, instr_assignment_id
1961: into l_instrument_id, l_instrument_type, l_instr_assignment_id
1962: from IBY_EXTN_INSTR_DETAILS_V
1963: where trxn_extension_id = p_trxn_extension_id;
1964: Exception When NO_DATA_FOUND THEN
1965: null;
1966: End;

Line 2259: From IBY_EXTN_INSTR_DETAILS_V

2255: IF p_payment_type_code in ('ACH', 'DIRECT_DEBIT') then
2256: -- bug 8586227
2257: Select account_number
2258: Into x_bank_account_number
2259: From IBY_EXTN_INSTR_DETAILS_V
2260: Where trxn_extension_id = l_trxn_extension_id;
2261: ELSIF p_payment_type_code = 'CREDIT_CARD' THEN
2262: -- bug 8586227
2263: /*Select itev.card_number,

Line 2304: IBY_EXTN_INSTR_DETAILS_V ITEV,

2300: x_instrument_security_code,
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;

Line 2509: from IBY_EXTN_INSTR_DETAILS_V itev ,

2505: into l_payment_channel_code,l_settled_flag,l_authorized_flag -- bug 5194228
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 (+)

Line 2538: IBY_EXTN_INSTR_DETAILS_V itev where

2534: END IF;
2535: -- bug 8586227
2536: select ifpai.acct_site_use_id into l_site_use_id
2537: from iby_fndcpt_payer_assgn_instr_v ifpai,
2538: IBY_EXTN_INSTR_DETAILS_V itev where
2539: ifpai.instr_assignment_id = itev.instr_assignment_id and
2540: itev.trxn_extension_id = p_trxn_extension_id;
2541: ELSE
2542: IF l_debug_level > 0 THEN