APPS.CSM_CUSTOMER_ACCOUNT_EVENT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21

SELECT 	hzc.CUST_ACCOUNT_ID
FROM 	HZ_CUST_ACCOUNTS hzc
WHERE 	hzc.PARTY_ID = c_party_id
AND NOT EXISTS
	(
	SELECT 	1
	FROM 	CSM_HZ_CUST_ACCOUNTS_ACC acc
	WHERE 	acc.USER_ID = c_user_id
	AND		acc.CUST_ACCOUNT_ID = hzc.CUST_ACCOUNT_ID
	);

Line: 45

   		CSM_ACC_PKG.Insert_Acc
    	(P_PUBLICATION_ITEM_NAMES => g_accnt_pubi_name
     	,P_ACC_TABLE_NAME         => g_cst_accnt_acc_table_name
     	,P_SEQ_NAME               => g_cst_accnt_seq_name
     	,P_PK1_NAME               => g_cst_accnt_pk1_name
     	,P_PK1_NUM_VALUE          => l_cust_accnt_rec.CUST_ACCOUNT_ID
     	,P_USER_ID                => p_user_id
    	);

Line: 77

SELECT 	acc.access_id,acc.user_id
FROM 	HZ_CUST_ACCOUNTS hzc , CSM_HZ_CUST_ACCOUNTS_ACC acc
WHERE 	hzc.cust_account_id = acc.cust_account_id
AND 	hzc.LAST_UPDATE_DATE > c_last_run_date;

Line: 85

SELECT 	nvl(last_run_date, (sysdate - 365*50) )
FROM 	jtm_con_request_data
WHERE 	package_name 	= 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG'
AND 	procedure_name 	= 'CUST_ACCOUNTS_UPD';

Line: 110

			l_userid_lst.DELETE;

Line: 113

			l_accessid_lst.DELETE;

Line: 125

	UPDATE 	jtm_con_request_data
	SET 	last_run_date   = sysdate
	WHERE 	package_name 	= 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG'
	AND 	procedure_name 	= 'CUST_ACCOUNTS_UPD';

Line: 158

SELECT 	acc.CUST_ACCOUNT_ID,acc.access_id
FROM 	CSM_HZ_CUST_ACCOUNTS_ACC acc
WHERE 	acc.USER_ID = c_user_id
AND NOT EXISTS
	(
	SELECT 	1
	FROM 	CSM_PARTIES_ACC acc
	WHERE 	acc.USER_ID  = c_user_id
	AND		acc.party_ID = c_party_id
	);

Line: 184

   		CSM_ACC_PKG.Delete_Acc
    	(P_PUBLICATION_ITEM_NAMES => g_accnt_pubi_name
     	,P_ACC_TABLE_NAME         => g_cst_accnt_acc_table_name
     	,P_PK1_NAME               => g_cst_accnt_pk1_name
     	,P_PK1_NUM_VALUE          => l_cust_accnt_rec.CUST_ACCOUNT_ID
     	,P_USER_ID                => p_user_id
    	);