APPS.AHL_UMP_NONROUTINES_PVT dependencies on AHL_UNIT_DEFERRALS_VL

Line 631: FROM ahl_unit_deferrals_vl

627: c_unit_effectivity_id number
628: )
629: IS
630: SELECT *
631: FROM ahl_unit_deferrals_vl
632: WHERE unit_effectivity_id = c_unit_effectivity_id AND
633: unit_deferral_type IN ('MEL','CDL');
634: -- may need to add more validations here to get the right deferral record...
635:

Line 3462: FROM ahl_unit_deferrals_vl

3458: attribute_category, attribute1,
3459: attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
3460: attribute8, attribute9, attribute10, attribute11, attribute12,
3461: attribute13, attribute14, attribute15
3462: FROM ahl_unit_deferrals_vl
3463: WHERE unit_deferral_id = p_deferral_id;
3464:
3465: -- get new UE for the incident ID deferred.
3466: CURSOR get_new_ue_csr (p_cs_incident_id IN NUMBER) IS