DBA Data[Home] [Help]

APPS.IEX_UTILITIES dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 5497: from iex_delinquencies_all del,ra_customer_trx_lines_all trl

5493: iex_debug_pub.logmessage ('p_contract_number :' || p_contract_number);
5494:
5495: IF p_contract_number IS NOT NULL then
5496: select count(1) into l_count
5497: from iex_delinquencies_all del,ra_customer_trx_lines_all trl
5498: where del.TRANSACTION_ID = trl.CUSTOMER_TRX_ID
5499: and del.status not in ('CURRENT', 'CLOSE')
5500: and trl.INTERFACE_LINE_CONTEXT = 'OKL_CONTRACTS'
5501: and trl.INTERFACE_LINE_ATTRIBUTE6 = p_contract_number;