DBA Data[Home] [Help]

APPS.IEX_UTILITIES dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 2436: from iex_delinquencies_all del,ra_customer_trx_lines_all trl

2432: iex_debug_pub.logmessage ('p_contract_number :' || p_contract_number);
2433:
2434: IF p_contract_number IS NOT NULL then
2435: select count(1) into l_count
2436: from iex_delinquencies_all del,ra_customer_trx_lines_all trl
2437: where del.TRANSACTION_ID = trl.CUSTOMER_TRX_ID
2438: and del.status not in ('CURRENT', 'CLOSE')
2439: and trl.INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS'
2440: and trl.INTERFACE_LINE_ATTRIBUTE6 = p_contract_number;