APPS.AHL_UMP_SR_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 971: FROM AHL_UNIT_EFFECTIVITIES_APP_V

967: AND INC.OBJECT_VERSION_NUMBER = p_object_version_number;
968:
969: CURSOR get_ue_dtls_csr(p_request_id IN NUMBER) IS
970: SELECT UNIT_EFFECTIVITY_ID
971: FROM AHL_UNIT_EFFECTIVITIES_APP_V
972: WHERE CS_INCIDENT_ID = p_request_id
973: AND (STATUS_CODE IS NULL OR STATUS_CODE NOT IN (G_UMP_DEFERRED_STATUS, G_UMP_EXCEPTION_STATUS));
974:
975: CURSOR get_tasks_for_ue_csr(p_ue_id IN NUMBER) IS

Line 1101: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE

1097: CURSOR validate_mr_ue_csr(p_mr_ue_id IN NUMBER,
1098: p_mr_ue_ovn IN NUMBER,
1099: p_sr_ue_id IN NUMBER) IS
1100: SELECT 'x'
1101: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1102: WHERE UE.UNIT_EFFECTIVITY_ID = p_mr_ue_id AND
1103: UE.OBJECT_VERSION_NUMBER = p_mr_ue_ovn AND
1104: EXISTS (SELECT 'x' from AHL_UE_RELATIONSHIPS UR
1105: WHERE UR.UE_ID = p_sr_ue_id AND

Line 1658: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE

1654: p_sr_ue_id IN NUMBER) IS
1655: /* AMSRINIV : Bug 5208411 : Below Query Tuned */
1656:
1657: /* SELECT UE.UNIT_EFFECTIVITY_ID
1658: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1659: WHERE UE.MR_HEADER_ID = (SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_APP_V
1660: WHERE MR_HEADER_ID like DECODE(p_mr_header_id, null, '%', p_mr_header_id) AND
1661: TITLE like DECODE(p_mr_header_id, null, p_mr_title, '%') AND
1662: VERSION_NUMBER like DECODE(p_mr_header_id, null, p_mr_version, '%')) AND

Line 1674: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE

1670: RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE);*/
1671:
1672: /* AMSRINIV : Bug 5208411 : Tuned query */
1673: SELECT UE.UNIT_EFFECTIVITY_ID
1674: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1675: WHERE UE.MR_HEADER_ID =
1676: (SELECT MR_HEADER_ID
1677: FROM AHL_MR_HEADERS_APP_V
1678: WHERE MR_HEADER_ID = NVL(p_mr_header_id,MR_HEADER_ID)

Line 2210: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_APP_V UE

2206: RETURN VARCHAR2 IS
2207:
2208: CURSOR get_mr_title_csr IS
2209: SELECT MR.TITLE
2210: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_APP_V UE
2211: WHERE UE.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id AND
2212: UE.MR_HEADER_ID = MR.MR_HEADER_ID;
2213:
2214: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;

Line 2234: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V

2230: p_new_tolerance_flag IN VARCHAR2,
2231: p_new_due_date IN DATE) IS
2232:
2233: CURSOR get_MR_UEs_csr IS
2234: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V
2235: WHERE UNIT_EFFECTIVITY_ID IN (SELECT RELATED_UE_ID from AHL_UE_RELATIONSHIPS
2236: WHERE ORIGINATOR_UE_ID = p_sr_ue_id
2237: AND RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE);
2238:

Line 2351: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V

2347: x_assigned_to_visit_flag OUT NOCOPY BOOLEAN,
2348: x_new_tolerance_flag OUT NOCOPY VARCHAR2) IS
2349:
2350: CURSOR get_UE_dtls_csr IS
2351: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V
2352: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2353:
2354: -- bachandr Bug # 13916897
2355: CURSOR c_get_incident_occ_date(c_incident_id IN NUMBER) IS

Line 2545: FROM AHL_UNIT_EFFECTIVITIES_APP_V

2541: WHERE INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id;
2542:
2543: CURSOR get_ue_dtls_csr IS
2544: SELECT UNIT_EFFECTIVITY_ID, OBJECT_VERSION_NUMBER, DEFER_FROM_UE_ID
2545: FROM AHL_UNIT_EFFECTIVITIES_APP_V
2546: WHERE CS_INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id
2547: AND (STATUS_CODE IS NULL OR STATUS_CODE NOT IN (G_UMP_DEFERRED_STATUS, G_UMP_EXCEPTION_STATUS));
2548:
2549: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Validate_Request_For_Update';