APPS.IEX_METRIC_CONCUR_PVT dependencies on IEX_DELINQUENCIES_ALL

Line 32: AND EXISTS ( select 1 from IEX_DELINQUENCIES_ALL del

28: WHERE p.status = 'A'
29: AND ca.status = 'A'
30: AND ca.party_id = p.party_id
31: --Begin Bug 7477844 24-Dec-2008 barathsr
32: AND EXISTS ( select 1 from IEX_DELINQUENCIES_ALL del
33: where del.party_cust_id= p.party_id
34: and del.status in ('DELINQUENT', 'PREDELINQUENT'));
35: --End Bug 7477844 24-Dec-2008 barathsr
36:

Line 44: AND EXISTS ( select 1 from IEX_DELINQUENCIES_ALL del

40: WHERE p.status = 'A'
41: AND ca.status = 'A'
42: AND ca.party_id = p.party_id
43: --Begin Bug 7477844 24-Dec-2008 barathsr
44: AND EXISTS ( select 1 from IEX_DELINQUENCIES_ALL del
45: where del.cust_account_id= ca.cust_account_id
46: and del.status in ('DELINQUENT', 'PREDELINQUENT'));
47: --End Bug 7477844 24-Dec-2008 barathsr
48:

Line 62: AND EXISTS ( select 1 from IEX_DELINQUENCIES_ALL del

58: AND ca.status = 'A'
59: AND acct_site.status = 'A'
60: AND site_uses.status = 'A'
61: --Begin Bug 7477844 24-Dec-2008 barathsr
62: AND EXISTS ( select 1 from IEX_DELINQUENCIES_ALL del
63: where del.customer_site_use_id= site_uses.site_use_id
64: and del.status in ('DELINQUENT', 'PREDELINQUENT'));
65: --End Bug 7477844 24-Dec-2008 barathsr
66: