APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 73: FROM jtm_con_request_data

69:
70: CURSOR l_upd_last_run_date_csr
71: IS
72: SELECT 1
73: FROM jtm_con_request_data
74: WHERE product_code = 'CSM'
75: AND package_name = 'CSM_TASK_ASSIGNMENT_EVENT_PKG'
76: AND procedure_name = 'PURGE_TASK_ASSIGNMENTS_CONC'
77: FOR UPDATE OF last_run_date NOWAIT

Line 124: UPDATE jtm_con_request_data

120: -- update last_run_date
121: OPEN l_upd_last_run_date_csr;
122: FETCH l_upd_last_run_date_csr INTO l_dummy;
123: IF l_upd_last_run_date_csr%FOUND THEN
124: UPDATE jtm_con_request_data
125: SET last_run_date = l_last_run_date
126: WHERE CURRENT OF l_upd_last_run_date_csr;
127: END IF;
128: CLOSE l_upd_last_run_date_csr;