The following lines contain the word 'select', 'insert', 'update' or 'delete':
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
);
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
);
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;
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';
l_userid_lst.DELETE;
l_accessid_lst.DELETE;
UPDATE jtm_con_request_data
SET last_run_date = sysdate
WHERE package_name = 'CSM_CUSTOMER_ACCOUNT_EVENT_PKG'
AND procedure_name = 'CUST_ACCOUNTS_UPD';
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
);
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
);