APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UNIT_DEFERRALS_VL

Line 574: FROM ahl_unit_deferrals_vl

570: c_unit_effectivity_id number
571: )
572: IS
573: SELECT *
574: FROM ahl_unit_deferrals_vl
575: WHERE unit_effectivity_id = c_unit_effectivity_id AND
576: unit_deferral_type IN ('MEL','CDL');
577: -- may need to add more validations here to get the right deferral record...
578:

Line 3288: FROM ahl_unit_deferrals_vl

3284: attribute_category, attribute1,
3285: attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
3286: attribute8, attribute9, attribute10, attribute11, attribute12,
3287: attribute13, attribute14, attribute15
3288: FROM ahl_unit_deferrals_vl
3289: WHERE unit_deferral_id = p_deferral_id;
3290:
3291: -- get new UE for the incident ID deferred.
3292: CURSOR get_new_ue_csr (p_cs_incident_id IN NUMBER) IS