APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on CSM_PARTY_SITES_ACC

Line 28: AND EXISTS(SELECT 1 FROM CSM_PARTY_SITES_ACC ps

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
29: WHERE ps.PARTY_SITE_ID=hcas.party_site_id
30: AND ps.user_id=acc.user_id));
31:
32: CURSOR c_ins_cur

Line 35: from hz_cust_acct_sites_all hcas,CSM_PARTY_SITES_ACC ps

31:
32: CURSOR c_ins_cur
33: IS
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