APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 475: FROM jtm_con_request_data

471:
472: CURSOR l_upd_last_run_date_csr
473: IS
474: SELECT 1
475: FROM jtm_con_request_data
476: WHERE product_code = 'CSM'
477: AND package_name = 'CSM_SERVICE_HISTORY_EVENT_PKG'
478: AND procedure_name = 'CONCURRENT_HISTORY'
479: FOR UPDATE OF last_run_date NOWAIT ;

Line 513: UPDATE jtm_con_request_data

509: -- update last_run_date
510: OPEN l_upd_last_run_date_csr;
511: FETCH l_upd_last_run_date_csr INTO l_dummy;
512: IF l_upd_last_run_date_csr%FOUND THEN
513: UPDATE jtm_con_request_data
514: SET last_run_date = l_last_run_date
515: WHERE CURRENT OF l_upd_last_run_date_csr;
516: END IF;
517: CLOSE l_upd_last_run_date_csr;