DBA Data[Home] [Help]

APPS.CSL_MTL_SERIAL_NUMBERS_ACC_PKG dependencies on JTM_CON_REQUEST_DATA

Line 335: from JTM_CON_REQUEST_DATA

331: /*** get the last run date of the concurent program ***/
332: CURSOR c_LastRundate
333: IS
334: select LAST_RUN_DATE
335: from JTM_CON_REQUEST_DATA
336: where package_name = 'CSL_MTL_SERIAL_NUMBERS_ACC_PKG'
337: AND procedure_name = 'CON_REQUEST_SERIAL_NUMBERS';
338:
339: BEGIN

Line 366: UPDATE JTM_CON_REQUEST_DATA

362: );
363: END IF;
364:
365: /*Update the last run date*/
366: UPDATE JTM_CON_REQUEST_DATA
367: SET LAST_RUN_DATE = SYSDATE
368: WHERE package_name = 'CSL_MTL_SERIAL_NUMBERS_ACC_PKG'
369: AND procedure_name = 'CON_REQUEST_SERIAL_NUMBERS';
370: