DBA Data[Home] [Help]

APPS.IEX_PROMISES_BATCH_PUB dependencies on IEX_DELINQUENCIES_ALL

Line 147: IEX_DELINQUENCIES_ALL DEL

143: SELECT
144: PRD.PROMISE_DETAIL_ID
145: FROM
146: IEX_PROMISE_DETAILS PRD,
147: IEX_DELINQUENCIES_ALL DEL
148: WHERE
149: DEL.DELINQUENCY_ID = PRD.DELINQUENCY_ID AND
150: DEL.CUST_ACCOUNT_ID = PRD.CUST_ACCOUNT_ID AND
151: DEL.PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID AND

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'