APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UNIT_THRESHOLDS

Line 312: --FROM ahl_unit_thresholds

308:
309: -- Cursor to check if init-due excepion still valid.
310: CURSOR exception_init_due_csr (p_unit_effectivity_id IN NUMBER) IS
311: SELECT unit_deferral_id
312: --FROM ahl_unit_thresholds
313: FROM ahl_unit_deferrals_b
314: WHERE unit_effectivity_id = p_unit_effectivity_id
315: AND unit_deferral_type = 'INIT-DUE';
316:

Line 1294: DELETE from ahl_unit_thresholds

1290:
1291: OPEN exception_init_due_csr (exception_rec.unit_effectivity_id);
1292: FETCH exception_init_due_csr INTO l_unit_deferral_id;
1293: IF (exception_init_due_csr%FOUND) THEN
1294: DELETE from ahl_unit_thresholds
1295: WHERE unit_deferral_id = l_unit_deferral_id;
1296:
1297: AHL_UNIT_DEFERRALS_PKG.Delete_Row(l_unit_deferral_id);
1298: END IF;