APPS.HZ_IMP_LOAD_STAGE1 dependencies on HZ_IMP_WORK_UNITS

Line 51: from hz_imp_work_units

47: status */
48: IF P_RERUN = 'U' OR P_RERUN = 'L' THEN
49: BEGIN
50: select hwm_stage into l_hwm_stage
51: from hz_imp_work_units
52: where batch_id = P_BATCH_ID
53: and orig_system = P_OS
54: and from_orig_system_ref = P_FROM_OSR;
55:

Line 76: UPDATE HZ_IMP_WORK_UNITS

72:
73: HZ_IMP_LOAD_SSM_MATCHING_PKG.MATCH_PARTIES(P_BATCH_ID, P_OS, P_FROM_OSR, P_TO_OSR, P_ACTUAL_CONTENT_SRC, l_rerun, P_BATCH_MODE_FLAG);
74:
75: /* Update status to Complete for the work unit that just finished */
76: UPDATE HZ_IMP_WORK_UNITS
77: SET STATUS = 'C'
78: WHERE BATCH_ID = P_BATCH_ID
79: AND FROM_ORIG_SYSTEM_REF = P_FROM_OSR;
80: