DBA Data[Home] [Help]

APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_PAYMENTS

Line 106: FROM oe_payments op,

102: /*
103: BEGIN
104: SELECT ite.instrument_id
105: INTO l_instrument_id
106: FROM oe_payments op,
107: iby_trxn_extensions_v ite
108: WHERE op.header_id = p_header_id
109: AND op.trxn_extension_id = ite.trxn_extension_id;
110: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 118: FROM oe_payments op,

114:
115: BEGIN
116: SELECT u.instrument_id
117: INTO l_instrument_id
118: FROM oe_payments op,
119: iby_pmt_instr_uses_all u,
120: iby_fndcpt_tx_extensions x
121: WHERE op.header_id = p_header_id
122: AND op.payment_type_code = 'CREDIT_CARD'