APPS.OE_PAYMENT_TRXN_UTIL dependencies on IBY_EXTN_SETTLEMENTS_V

Line 1332: IBY_EXTN_SETTLEMENTS_V iset

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;
1336:

Line 2511: IBY_EXTN_SETTLEMENTS_V iset

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;
2515:

Line 2798: from IBY_EXTN_SETTLEMENTS_V

2794: NOT OE_GLOBALS.Equal(p_trxn_Extension_id, FND_API.G_MISS_NUM) THEN
2795: -- bug 8586227
2796: select settled_flag
2797: into l_Settled_flag
2798: from IBY_EXTN_SETTLEMENTS_V
2799: where trxn_Extension_id = p_trxn_extension_id;
2800: END IF;
2801: IF l_debug_level > 0 THEN
2802: oe_debug_pub.add('Settled flag retrieved successfully...');

Line 3097: FROM IBY_EXTN_SETTLEMENTS_V

3093:
3094: BEGIN
3095: SELECT nvl(settled_flag, 'N')
3096: INTO l_settled_flag
3097: FROM IBY_EXTN_SETTLEMENTS_V
3098: WHERE trxn_extension_id = l_trxn_extension_id;
3099: EXCEPTION WHEN NO_DATA_FOUND THEN
3100: l_settled_flag := 'N';
3101: WHEN OTHERS then