APPS.AHL_PRD_DF_PVT dependencies on AHL_UNIT_EFFECTIVITIES_V

Line 3772: SELECT title from ahl_unit_effectivities_v

3768: --Changes by nsikka for Bug 5324101
3769: --Cursor added to fetch UE Title to be passed as token
3770:
3771: CURSOR ue_title_csr(p_unit_effectivity_id IN NUMBER) IS
3772: SELECT title from ahl_unit_effectivities_v
3773: WHERE UNIT_EFFECTIVITY_ID = p_unit_effectivity_id;
3774:
3775: l_update_flag BOOLEAN := false;
3776: --l_complete_flag BOOLEAN := false; /* commented out as workorder completion is no longer needed. */

Line 4294: FROM AHL_UNIT_EFFECTIVITIES_VL UE

4290: POSITION_PATH_ID, ATA_CODE, UNIT_CONFIG_HEADER_ID,
4291: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
4292: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,ATTRIBUTE9,
4293: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14,ATTRIBUTE15
4294: FROM AHL_UNIT_EFFECTIVITIES_VL UE
4295: WHERE unit_effectivity_id = p_unit_effectivity_id
4296: UNION
4297: SELECT
4298: UNIT_EFFECTIVITY_ID, OBJECT_VERSION_NUMBER, CSI_ITEM_INSTANCE_ID, MR_INTERVAL_ID,

Line 4310: FROM AHL_UNIT_EFFECTIVITIES_VL UE

4306: POSITION_PATH_ID, ATA_CODE, UNIT_CONFIG_HEADER_ID,
4307: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
4308: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,ATTRIBUTE9,
4309: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14,ATTRIBUTE15
4310: FROM AHL_UNIT_EFFECTIVITIES_VL UE
4311: WHERE unit_effectivity_id IN
4312: (
4313:
4314: SELECT distinct related_ue_id

Line 4835: FROM AHL_UNIT_EFFECTIVITIES_VL UE

4831: POSITION_PATH_ID, ATA_CODE, UNIT_CONFIG_HEADER_ID,
4832: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3,
4833: ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,ATTRIBUTE9,
4834: ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14,ATTRIBUTE15
4835: FROM AHL_UNIT_EFFECTIVITIES_VL UE
4836: WHERE unit_effectivity_id = p_unit_effectivity_id;
4837:
4838: CURSOR redundant_deferral_ue_csr(p_unit_effectivity_id IN NUMBER) IS
4839: SELECT UD.unit_deferral_id FROM ahl_unit_deferrals_b UD