APPS.IEX_METRIC_CONCUR_PVT dependencies on HZ_CUST_ACCOUNTS

Line 26: FROM hz_parties p, hz_cust_accounts ca

22: l_msg_count NUMBER;
23:
24: CURSOR c_party IS
25: SELECT distinct p.party_id
26: FROM hz_parties p, hz_cust_accounts ca
27: WHERE p.status = 'A'
28: AND ca.status = 'A'
29: AND ca.party_id = p.party_id;
30:

Line 33: FROM hz_parties p, hz_cust_accounts ca

29: AND ca.party_id = p.party_id;
30:
31: CURSOR c_account IS
32: SELECT ca.cust_account_id, p.party_id
33: FROM hz_parties p, hz_cust_accounts ca
34: WHERE p.status = 'A'
35: AND ca.status = 'A'
36: AND ca.party_id = p.party_id;
37:

Line 41: FROM hz_cust_accounts ca, hz_parties p,

37:
38: CURSOR c_billto IS
39: SELECT site_uses.site_use_id site_use_id, ca.cust_account_id cust_account_id, p.party_id,
40: acct_site.org_id
41: FROM hz_cust_accounts ca, hz_parties p,
42: hz_cust_acct_sites acct_site,hz_cust_site_uses site_uses
43: WHERE acct_site.cust_acct_site_id = site_uses.cust_acct_site_id
44: AND acct_site.cust_account_id = ca.cust_account_id
45: AND ca.party_id = p.party_id