[Home] [Help]
APPS.IEX_PROMISES_BATCH_PUB dependencies on HZ_CUST_ACCOUNTS
Line 2801: FROM IEX_PROMISE_DETAILS pro, HZ_CUST_ACCOUNTS hca, iex_delinquencies idel
2797: pro.resource_id,
2798: pro.cust_account_id,
2799: idel.customer_site_use_id,
2800: idel.delinquency_id
2801: FROM IEX_PROMISE_DETAILS pro, HZ_CUST_ACCOUNTS hca, iex_delinquencies idel
2802: WHERE
2803: pro.cust_account_id = hca.cust_account_id
2804: AND idel.delinquency_id(+) = pro.delinquency_id
2805: AND pro.status = 'COLLECTABLE'