APPS.IEX_METRIC_CONCUR_PVT dependencies on HZ_CUST_ACCOUNTS

Line 27: FROM hz_parties p, hz_cust_accounts ca

23: l_obj_count NUMBER; --Added for Bug 7477844 24-Dec-2008 barathsr
24:
25: CURSOR c_party IS
26: SELECT distinct p.party_id
27: FROM hz_parties p, hz_cust_accounts ca
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

Line 39: FROM hz_parties p, hz_cust_accounts ca

35: --End Bug 7477844 24-Dec-2008 barathsr
36:
37: CURSOR c_account IS
38: SELECT ca.cust_account_id, p.party_id
39: FROM hz_parties p, hz_cust_accounts ca
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

Line 52: FROM hz_cust_accounts ca, hz_parties p,

48:
49: CURSOR c_billto IS
50: SELECT site_uses.site_use_id site_use_id, ca.cust_account_id cust_account_id, p.party_id,
51: acct_site.org_id
52: FROM hz_cust_accounts ca, hz_parties p,
53: hz_cust_acct_sites acct_site,hz_cust_site_uses site_uses
54: WHERE acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
55: AND acct_site.cust_account_id = ca.cust_account_id
56: AND ca.party_id = p.party_id