APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UNIT_THRESHOLDS

Line 247: --FROM ahl_unit_thresholds

243:
244: -- Cursor to check if init-due excepion still valid.
245: CURSOR exception_init_due_csr (p_unit_effectivity_id IN NUMBER) IS
246: SELECT unit_deferral_id
247: --FROM ahl_unit_thresholds
248: FROM ahl_unit_deferrals_b
249: WHERE unit_effectivity_id = p_unit_effectivity_id
250: AND unit_deferral_type = 'INIT-DUE';
251:

Line 923: DELETE from ahl_unit_thresholds

919:
920: OPEN exception_init_due_csr (exception_rec.unit_effectivity_id);
921: FETCH exception_init_due_csr INTO l_unit_deferral_id;
922: IF (exception_init_due_csr%FOUND) THEN
923: DELETE from ahl_unit_thresholds
924: WHERE unit_deferral_id = l_unit_deferral_id;
925:
926: AHL_UNIT_DEFERRALS_PKG.Delete_Row(l_unit_deferral_id);
927: END IF;