APPS.CSM_QUERY_EVENT_PKG dependencies on CSM_QUERY_VARIABLE_VALUES_ACC

Line 139: FROM CSM_QUERY_VARIABLE_VALUES_ACC acc

135: CURSOR c_query_variables_val_del
136: IS
137: SELECT acc.ACCESS_ID,
138: acc.USER_ID
139: FROM CSM_QUERY_VARIABLE_VALUES_ACC acc
140: WHERE NOT EXISTS
141: (SELECT 1 FROM CSM_QUERY_INSTANCES_ACC iacc
142: WHERE iacc.USER_ID = acc.USER_ID
143: AND iacc.INSTANCE_ID = acc.INSTANCE_ID

Line 295: DELETE FROM CSM_QUERY_VARIABLE_VALUES_ACC WHERE access_id = l_access_list(i);

291: p_timestamp => l_run_date);
292:
293: END LOOP;
294: FORALL i IN 1..l_access_list.count
295: DELETE FROM CSM_QUERY_VARIABLE_VALUES_ACC WHERE access_id = l_access_list(i);
296:
297: COMMIT;
298:
299: END LOOP;