APPS.IEX_BUS_EVENT_SUB_PVT dependencies on IEX_DELINQUENCIES_ALL

Line 650: FROM iex_delinquencies_all a,

646: SUM(decode(trx_summ.currency, gl.CURRENCY_CODE, trx_summ.op_invoices_value,
647: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
648: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
649: (SELECT SUM(b.acctd_amount_due_remaining)
650: FROM iex_delinquencies_all a,
651: ar_payment_schedules_all b
652: WHERE a.customer_site_use_id = trx_summ.site_use_id
653: AND a.payment_schedule_id = b.payment_schedule_id
654: AND b.status = 'OP'

Line 720: FROM iex_delinquencies_all a,

716: SUM(decode(trx_summ.currency, gl.CURRENCY_CODE, trx_summ.op_invoices_value,
717: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
718: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
719: (SELECT SUM(b.acctd_amount_due_remaining)
720: FROM iex_delinquencies_all a,
721: ar_payment_schedules_all b
722: WHERE a.cust_account_id = trx_summ.cust_account_id
723: AND a.payment_schedule_id = b.payment_schedule_id
724: AND b.status = 'OP'

Line 790: FROM iex_delinquencies_all a,

786: SUM(decode(trx_summ.currency, gl.CURRENCY_CODE, trx_summ.op_invoices_value,
787: gl_currency_api.convert_amount_sql(trx_summ.currency, gl.CURRENCY_CODE, sysdate,
788: iex_utilities.get_cache_value('DEFAULT_EXCHANGE_RATE_TYPE', ''), trx_summ.op_invoices_value))) op_invoices_value,
789: (SELECT SUM(b.acctd_amount_due_remaining)
790: FROM iex_delinquencies_all a,
791: ar_payment_schedules_all b
792: WHERE a.party_cust_id = party.party_id
793: AND a.payment_schedule_id = b.payment_schedule_id
794: AND b.status = 'OP'