APPS.IEX_BUS_EVENT_SUB_PVT dependencies on IEX_DELINQUENCIES_ALL

Line 639: FROM iex_delinquencies_all a,

635: SUM(decode(trx_summ.currency, gl.CURRENCY_CODE, trx_summ.op_invoices_value,
636: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
637: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
638: (SELECT SUM(b.acctd_amount_due_remaining)
639: FROM iex_delinquencies_all a,
640: ar_payment_schedules_all b
641: WHERE a.customer_site_use_id = trx_summ.site_use_id
642: AND a.payment_schedule_id = b.payment_schedule_id
643: AND b.status = 'OP'

Line 709: FROM iex_delinquencies_all a,

705: SUM(decode(trx_summ.currency, gl.CURRENCY_CODE, trx_summ.op_invoices_value,
706: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
707: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
708: (SELECT SUM(b.acctd_amount_due_remaining)
709: FROM iex_delinquencies_all a,
710: ar_payment_schedules_all b
711: WHERE a.cust_account_id = trx_summ.cust_account_id
712: AND a.payment_schedule_id = b.payment_schedule_id
713: AND b.status = 'OP'

Line 779: FROM iex_delinquencies_all a,

775: SUM(decode(trx_summ.currency, gl.CURRENCY_CODE, trx_summ.op_invoices_value,
776: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
777: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
778: (SELECT SUM(b.acctd_amount_due_remaining)
779: FROM iex_delinquencies_all a,
780: ar_payment_schedules_all b
781: WHERE a.party_cust_id = party.party_id
782: AND a.payment_schedule_id = b.payment_schedule_id
783: AND b.status = 'OP'