APPS.CSM_SR_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 65: FROM jtm_con_request_data

61:
62: CURSOR l_upd_last_run_date_csr
63: IS
64: SELECT 1
65: FROM jtm_con_request_data
66: WHERE product_code = 'CSM'
67: AND package_name = 'CSM_SR_EVENT_PKG'
68: AND procedure_name = 'PURGE_INCIDENTS_CONC'
69: FOR UPDATE OF last_run_date NOWAIT;

Line 114: UPDATE jtm_con_request_data

110: -- update last_run_date
111: OPEN l_upd_last_run_date_csr;
112: FETCH l_upd_last_run_date_csr INTO l_dummy;
113: IF l_upd_last_run_date_csr%FOUND THEN
114: UPDATE jtm_con_request_data
115: SET last_run_date = l_last_run_date
116: WHERE CURRENT OF l_upd_last_run_date_csr;
117: END IF;
118: CLOSE l_upd_last_run_date_csr;