APPS.CSM_UTIL_PKG dependencies on JTM_CON_REQUEST_DATA

Line 1340: FROM jtm_con_request_data

1336:
1337: CURSOR l_upd_last_run_date_csr
1338: IS
1339: SELECT 1
1340: FROM jtm_con_request_data
1341: WHERE product_code = 'CSM'
1342: AND package_name = 'CSM_UTIL_PKG'
1343: AND procedure_name = 'REFRESH_ALL_APP_LEVEL_ACC'
1344: FOR UPDATE OF last_run_date NOWAIT

Line 1370: UPDATE jtm_con_request_data

1366: -- update last_run_date
1367: OPEN l_upd_last_run_date_csr;
1368: FETCH l_upd_last_run_date_csr INTO l_dummy;
1369: IF l_upd_last_run_date_csr%FOUND THEN
1370: UPDATE jtm_con_request_data
1371: SET last_run_date = l_last_run_date
1372: WHERE CURRENT OF l_upd_last_run_date_csr;
1373: END IF;
1374: CLOSE l_upd_last_run_date_csr;