DBA Data[Home] [Help]

APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_PAYMENTS

Line 59: FROM oe_payments op,

55: /*
56: BEGIN
57: SELECT ite.instrument_id
58: INTO l_instrument_id
59: FROM oe_payments op,
60: iby_trxn_extensions_v ite
61: WHERE op.header_id = p_header_id
62: AND op.trxn_extension_id = ite.trxn_extension_id;
63: EXCEPTION WHEN NO_DATA_FOUND THEN

Line 71: FROM oe_payments op,

67:
68: BEGIN
69: SELECT u.instrument_id
70: INTO l_instrument_id
71: FROM oe_payments op,
72: iby_pmt_instr_uses_all u,
73: iby_fndcpt_tx_extensions x
74: WHERE op.header_id = p_header_id
75: AND op.payment_type_code = 'CREDIT_CARD'