APPS.AHL_UMP_SR_PVT dependencies on AHL_UNIT_EFFECTIVITIES_APP_V

Line 937: FROM AHL_UNIT_EFFECTIVITIES_APP_V

933: AND INC.OBJECT_VERSION_NUMBER = p_object_version_number;
934:
935: CURSOR get_ue_dtls_csr(p_request_id IN NUMBER) IS
936: SELECT UNIT_EFFECTIVITY_ID
937: FROM AHL_UNIT_EFFECTIVITIES_APP_V
938: WHERE CS_INCIDENT_ID = p_request_id
939: AND (STATUS_CODE IS NULL OR STATUS_CODE NOT IN (G_UMP_DEFERRED_STATUS, G_UMP_EXCEPTION_STATUS));
940:
941: CURSOR get_tasks_for_ue_csr(p_ue_id IN NUMBER) IS

Line 1067: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE

1063: CURSOR validate_mr_ue_csr(p_mr_ue_id IN NUMBER,
1064: p_mr_ue_ovn IN NUMBER,
1065: p_sr_ue_id IN NUMBER) IS
1066: SELECT 'x'
1067: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1068: WHERE UE.UNIT_EFFECTIVITY_ID = p_mr_ue_id AND
1069: UE.OBJECT_VERSION_NUMBER = p_mr_ue_ovn AND
1070: EXISTS (SELECT 'x' from AHL_UE_RELATIONSHIPS UR
1071: WHERE UR.UE_ID = p_sr_ue_id AND

Line 1584: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE

1580: p_sr_ue_id IN NUMBER) IS
1581: /* AMSRINIV : Bug 5208411 : Below Query Tuned */
1582:
1583: /* SELECT UE.UNIT_EFFECTIVITY_ID
1584: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1585: WHERE UE.MR_HEADER_ID = (SELECT MR_HEADER_ID FROM AHL_MR_HEADERS_APP_V
1586: WHERE MR_HEADER_ID like DECODE(p_mr_header_id, null, '%', p_mr_header_id) AND
1587: TITLE like DECODE(p_mr_header_id, null, p_mr_title, '%') AND
1588: VERSION_NUMBER like DECODE(p_mr_header_id, null, p_mr_version, '%')) AND

Line 1600: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE

1596: RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE);*/
1597:
1598: /* AMSRINIV : Bug 5208411 : Tuned query */
1599: SELECT UE.UNIT_EFFECTIVITY_ID
1600: FROM AHL_UNIT_EFFECTIVITIES_APP_V UE
1601: WHERE UE.MR_HEADER_ID =
1602: (SELECT MR_HEADER_ID
1603: FROM AHL_MR_HEADERS_APP_V
1604: WHERE MR_HEADER_ID = NVL(p_mr_header_id,MR_HEADER_ID)

Line 2093: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_APP_V UE

2089: RETURN VARCHAR2 IS
2090:
2091: CURSOR get_mr_title_csr IS
2092: SELECT MR.TITLE
2093: FROM AHL_MR_HEADERS_B MR, AHL_UNIT_EFFECTIVITIES_APP_V UE
2094: WHERE UE.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id AND
2095: UE.MR_HEADER_ID = MR.MR_HEADER_ID;
2096:
2097: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE := null;

Line 2117: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V

2113: p_new_tolerance_flag IN VARCHAR2,
2114: p_new_due_date IN DATE) IS
2115:
2116: CURSOR get_MR_UEs_csr IS
2117: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V
2118: WHERE UNIT_EFFECTIVITY_ID IN (SELECT RELATED_UE_ID from AHL_UE_RELATIONSHIPS
2119: WHERE ORIGINATOR_UE_ID = p_sr_ue_id
2120: AND RELATIONSHIP_CODE = G_UE_PARENT_REL_CODE);
2121:

Line 2231: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V

2227: x_assigned_to_visit_flag OUT NOCOPY BOOLEAN,
2228: x_new_tolerance_flag OUT NOCOPY VARCHAR2) IS
2229:
2230: CURSOR get_UE_dtls_csr IS
2231: SELECT * FROM AHL_UNIT_EFFECTIVITIES_APP_V
2232: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2233:
2234: CURSOR is_ue_assigned_to_visit_csr IS
2235: SELECT 'x' FROM AHL_VISIT_TASKS_B

Line 2404: FROM AHL_UNIT_EFFECTIVITIES_APP_V

2400: WHERE INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id;
2401:
2402: CURSOR get_ue_dtls_csr IS
2403: SELECT UNIT_EFFECTIVITY_ID, OBJECT_VERSION_NUMBER
2404: FROM AHL_UNIT_EFFECTIVITIES_APP_V
2405: WHERE CS_INCIDENT_ID = CS_SERVICEREQUEST_PVT.user_hooks_rec.request_id
2406: AND (STATUS_CODE IS NULL OR STATUS_CODE NOT IN (G_UMP_DEFERRED_STATUS, G_UMP_EXCEPTION_STATUS));
2407:
2408: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Validate_Request_For_Update';