DBA Data[Home] [Help]

APPS.CSM_HA_EVENT_PKG dependencies on JTM_CON_REQUEST_DATA

Line 897: UPDATE JTM_CON_REQUEST_DATA

893: PROCEDURE MANAGE_MFS_CONC
894: IS
895: BEGIN
896:
897: UPDATE JTM_CON_REQUEST_DATA
898: SET EXECUTE_FLAG='N'
899: WHERE PRODUCT_CODE='CSM'
900: AND CATEGORY='LOOKUP'
901: AND (PACKAGE_NAME,PROCEDURE_NAME) NOT IN

Line 1439: FROM jtm_con_request_data

1435:
1436: CURSOR c_last_run_date
1437: IS
1438: SELECT NVL(last_run_date,to_date(1,'J'))
1439: FROM jtm_con_request_data
1440: WHERE package_name = 'CSM_LOBS_EVENT_PKG'
1441: AND procedure_name = 'CONC_DOWNLOAD_ATTACHMENTS';
1442:
1443: l_last_run_date DATE;