DBA Data[Home] [Help]

APPS.JMF_GTA_TRX_UTIL dependencies on IBY_PMT_INSTR_USES_ALL

Line 2099: IBY_PMT_INSTR_USES_ALL U,

2095: IBY_EXT_BANK_ACCOUNTS_V B,
2096: IBY_FNDCPT_PMT_CHNNLS_VL P,
2097: IBY_FNDCPT_TX_EXTENSIONS X,
2098: IBY_FNDCPT_TX_OPERATIONS OP,
2099: IBY_PMT_INSTR_USES_ALL U,
2100: HZ_PARTIES HZP,
2101: FND_APPLICATION A
2102: WHERE (x.instr_assignment_id = u.instrument_payment_use_id(+))
2103: AND (DECODE(u.instrument_type, 'CREDITCARD', u.instrument_id, NULL) =

Line 2191: FROM IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO

2187: FROM (SELECT ibybanks.bank_account_name
2188: , ibybanks.bank_account_num
2189: , ibybanks.bank_id
2190: , ibybanks.branch_id
2191: FROM IBY_PMT_INSTR_USES_ALL ExtPartyInstrumentsEO
2192: , IBY_EXT_BANK_ACCOUNTS ibybanks
2193: WHERE ibybanks.EXT_BANK_ACCOUNT_ID = ExtPartyInstrumentsEO.instrument_id
2194: AND ExtPartyInstrumentsEO.INSTRUMENT_TYPE = 'BANKACCOUNT'
2195: AND ExtPartyInstrumentsEO.EXT_PMT_PARTY_ID = l_ext_payer_id