APPS.CSM_COUNTER_PROPERTY_EVENT_PKG SQL Statements

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

Line: 28

SELECT
B.COUNTER_PROPERTY_ID ,
B.COUNTER_ID
FROM
CSI_COUNTER_PROPERTIES_B B,
CSM_COUNTERS_ACC		 CACC
WHERE B.COUNTER_ID    = CACC.COUNTER_ID
AND   CACC.USER_ID 	  = c_user_id
AND   CACC.COUNTER_ID = c_counter_id
AND NOT EXISTS( SELECT 1
				FROM   CSM_COUNTER_PROPERTIES_ACC PACC
				WHERE  PACC.COUNTER_PROPERTY_ID = B.COUNTER_PROPERTY_ID
				AND	   PACC.USER_ID = c_user_id);

Line: 53

      CSM_ACC_PKG.Insert_Acc
             ( P_PUBLICATION_ITEM_NAMES => g_count_prp_pubi_name
              ,P_ACC_TABLE_NAME         => g_count_prp_acc_table_name
              ,P_SEQ_NAME               => g_count_prp_seq_name
              ,P_PK1_NAME               => g_count_prp_pk1_name
              ,P_PK1_NUM_VALUE          => r_cntr_prp_rec.counter_property_id
              ,P_USER_ID                => p_user_id
             );

Line: 89

SELECT
PACC.ACCESS_ID ,
PACC.USER_ID
FROM
CSI_COUNTER_PROPERTIES_B B,
CSM_COUNTER_PROPERTIES_ACC PACC
WHERE B.COUNTER_PROPERTY_ID    = PACC.COUNTER_PROPERTY_ID
AND   PACC.USER_ID 	  = c_user_id
AND   B.COUNTER_ID 	  = c_counter_id;

Line: 145

SELECT
PACC.ACCESS_ID ,
B.COUNTER_PROPERTY_ID
FROM
CSI_COUNTER_PROPERTIES_B B,
CSM_COUNTER_PROPERTIES_ACC PACC
WHERE B.COUNTER_PROPERTY_ID    = PACC.COUNTER_PROPERTY_ID
AND   PACC.USER_ID 	  = c_user_id
AND   B.COUNTER_ID 	  = c_counter_id;

Line: 166

      CSM_ACC_PKG.Delete_Acc
             ( P_PUBLICATION_ITEM_NAMES => g_count_prp_pubi_name
              ,P_ACC_TABLE_NAME         => g_count_prp_acc_table_name
              ,P_PK1_NAME               => g_count_prp_pk1_name
              ,P_PK1_NUM_VALUE          => r_cntr_prp_rec.counter_property_id
              ,P_USER_ID                => p_user_id
             );