APPS.CSM_QUERY_EVENT_PKG dependencies on CSM_QUERY_INSTANCES_ACC

Line 126: FROM CSM_QUERY_INSTANCES_ACC acc,

122: CURSOR c_query_instances_del
123: IS
124: SELECT acc.ACCESS_ID,
125: acc.USER_ID
126: FROM CSM_QUERY_INSTANCES_ACC acc,
127: CSM_QUERY_B b
128: WHERE b.QUERY_ID = acc.QUERY_ID
129: AND ( NVL(b.DELETE_FLAG,'N') ='Y'
130: OR ( UPPER(b.RETENTION_POLICY) = 'AUTOMATIC'

Line 141: (SELECT 1 FROM CSM_QUERY_INSTANCES_ACC iacc

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
144: AND iacc.QUERY_ID = acc.QUERY_ID);
145:

Line 153: (SELECT 1 FROM CSM_QUERY_INSTANCES_ACC iacc

149: SELECT acc.ACCESS_ID,
150: acc.USER_ID
151: FROM CSM_QUERY_RESULTS_ACC acc
152: WHERE NOT EXISTS
153: (SELECT 1 FROM CSM_QUERY_INSTANCES_ACC iacc
154: WHERE iacc.USER_ID = acc.USER_ID
155: AND iacc.INSTANCE_ID = acc.INSTANCE_ID
156: AND iacc.QUERY_ID = acc.QUERY_ID);
157:

Line 265: DELETE FROM CSM_QUERY_INSTANCES_ACC WHERE access_id = l_access_list(i);

261: p_timestamp => l_run_date);
262:
263: END LOOP;
264: FORALL i IN 1..l_access_list.count
265: DELETE FROM CSM_QUERY_INSTANCES_ACC WHERE access_id = l_access_list(i);
266:
267: COMMIT;
268:
269: END LOOP;