APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 24: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu

20: FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC acc
21: WHERE NOT EXISTS(SELECT 1 from hz_cust_acct_sites_all hcas
22: WHERE acc.cust_acct_site_id=hcas.cust_acct_site_id
23: AND hcas.status='A'
24: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu
25: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
26: AND hcsu.site_use_code='SHIP_TO'
27: AND hcsu.status='A')
28: AND EXISTS(SELECT 1 FROM CSM_PARTY_SITES_ACC ps

Line 38: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu

34: select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, hcas.cust_acct_site_id,ps.user_id
35: from hz_cust_acct_sites_all hcas,CSM_PARTY_SITES_ACC ps
36: WHERE ps.PARTY_SITE_ID=hcas.party_site_id
37: AND hcas.status='A'
38: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu
39: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
40: AND hcsu.site_use_code='SHIP_TO'
41: AND hcsu.status='A')
42: AND NOT EXISTS(SELECT 1 FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC acc

Line 140: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu

136: from hz_cust_acct_sites_all hcas
137: where hcas.party_site_id = p_party_site_id
138: AND hcas.status='A' --download only active ones
139: And ORG_ID=p_org_id
140: AND EXISTS(SELECT 1 FROM hz_cust_site_uses_all hcsu
141: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
142: AND hcsu.site_use_code='SHIP_TO'
143: AND hcsu.status='A')
144: AND NOT EXISTS(SELECT 1 FROM CSM_HZ_CUST_ACCT_SITES_ALL_ACC acc