APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 135: FROM JTM_CON_REQUEST_DATA

131: /*** get the last run date of the concurent program ***/
132: CURSOR c_LastRundate
133: IS
134: SELECT NVL(LAST_RUN_DATE, to_date('1','J')) LAST_RUN_DATE
135: FROM JTM_CON_REQUEST_DATA
136: WHERE package_name = 'CSM_CSP_REQ_LINES_EVENT_PKG'
137: AND procedure_name = 'CONC_ORDER_UPDATE';
138:
139: r_LastRundate c_LastRundate%ROWTYPE;

Line 208: UPDATE JTM_CON_REQUEST_DATA

204: END LOOP;
205: END IF;--IF l_tab_access_id.COUNT > 0
206:
207:
208: UPDATE JTM_CON_REQUEST_DATA
209: SET LAST_RUN_DATE = l_current_run_date
210: WHERE package_name = 'CSM_CSP_REQ_LINES_EVENT_PKG'
211: AND procedure_name = 'CONC_ORDER_UPDATE';
212: