APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 325: FROM jtm_con_request_data

321:
322: CURSOR l_upd_last_run_date_csr
323: IS
324: SELECT 1
325: FROM jtm_con_request_data
326: WHERE product_code = 'CSM'
327: AND package_name = 'CSM_NOTIFICATION_EVENT_PKG'
328: AND procedure_name = 'PURGE_NOTIFICATION_CONC'
329: FOR UPDATE OF last_run_date NOWAIT

Line 372: UPDATE jtm_con_request_data

368: -- update last_run_date
369: OPEN l_upd_last_run_date_csr;
370: FETCH l_upd_last_run_date_csr INTO l_dummy;
371: IF l_upd_last_run_date_csr%FOUND THEN
372: UPDATE jtm_con_request_data
373: SET last_run_date = l_last_run_date
374: WHERE CURRENT OF l_upd_last_run_date_csr;
375: END IF;
376: CLOSE l_upd_last_run_date_csr;