APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG dependencies on CSM_HZ_CUST_ACCOUNTS_ACC_S

Line 5: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S' ;

1: PACKAGE BODY CSM_CUSTOMER_ACCOUNT_EVENT_PKG AS
2: /* $Header: csmecatb.pls 120.2.12020000.2 2013/04/09 06:23:47 saradhak ship $ */
3: g_cst_accnt_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC';
4: g_cst_accnt_table_name CONSTANT VARCHAR2(30) := 'HZ_CUST_ACCOUNTS';
5: g_cst_accnt_seq_name CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS_ACC_S' ;
6: g_cst_accnt_pk1_name CONSTANT VARCHAR2(30) := 'CUST_ACCOUNT_ID';
7: g_pub_item CONSTANT VARCHAR2(30) := 'CSM_HZ_CUST_ACCOUNTS';
8: g_accnt_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
9: CSM_ACC_PKG.t_publication_item_list('CSM_HZ_CUST_ACCOUNTS');

Line 34: select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, hcas.cust_acct_site_id,ps.user_id

30: AND ps.user_id=acc.user_id));
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

Line 135: OPEN c_ins_cur FOR select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, p_user_id,hcas.cust_acct_site_id

131: BEGIN
132:
133: CSM_UTIL_PKG.LOG('Entering CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS Package ', 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG.CUST_ACCT_SITES_INS',FND_LOG.LEVEL_PROCEDURE);
134:
135: OPEN c_ins_cur FOR select CSM_HZ_CUST_ACCOUNTS_ACC_S.nextval as ACCESS_ID, p_user_id,hcas.cust_acct_site_id
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