DBA Data[Home] [Help]

APPS.HZ_IMP_LOAD_STAGE1 dependencies on HZ_IMP_BATCH_DETAILS

Line 102: UPDATE hz_imp_batch_details

98: UPDATE hz_imp_batch_summary
99: SET import_status = 'ERROR'
100: WHERE batch_id = P_BATCH_ID;
101:
102: UPDATE hz_imp_batch_details
103: SET import_status = 'ERROR'
104: WHERE batch_id = P_BATCH_ID
105: AND run_number = (SELECT max(run_number)
106: FROM hz_imp_batch_details

Line 106: FROM hz_imp_batch_details

102: UPDATE hz_imp_batch_details
103: SET import_status = 'ERROR'
104: WHERE batch_id = P_BATCH_ID
105: AND run_number = (SELECT max(run_number)
106: FROM hz_imp_batch_details
107: WHERE batch_id = P_BATCH_ID);
108:
109: COMMIT;
110: