DBA Data[Home] [Help]

APPS.IEX_PROMISES_BATCH_PUB dependencies on HZ_CUST_ACCOUNTS

Line 2655: FROM IEX_PROMISE_DETAILS pro, HZ_CUST_ACCOUNTS hca, iex_delinquencies_all idel

2651: pro.resource_id,
2652: pro.cust_account_id,
2653: idel.customer_site_use_id,
2654: idel.delinquency_id
2655: FROM IEX_PROMISE_DETAILS pro, HZ_CUST_ACCOUNTS hca, iex_delinquencies_all idel
2656: WHERE
2657: pro.cust_account_id = hca.cust_account_id
2658: AND idel.delinquency_id(+) = pro.delinquency_id
2659: AND pro.state = 'BROKEN_PROMISE'