APPS.AHL_UMP_SR_PVT dependencies on AHL_VISIT_TASKS_B

Line 976: SELECT 'x' from AHL_VISIT_TASKS_B

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
976: SELECT 'x' from AHL_VISIT_TASKS_B
977: where UNIT_EFFECTIVITY_ID = p_ue_id;
978:
979: l_sr_status_id NUMBER := NULL;
980: l_closed_flag CS_INCIDENTS_V.CLOSED_FLAG%TYPE := NULL;

Line 2363: SELECT 'x' FROM AHL_VISIT_TASKS_B

2359: l_occurred_date DATE;
2360: -- bachandr Bug # 13916897
2361:
2362: CURSOR is_ue_assigned_to_visit_csr IS
2363: SELECT 'x' FROM AHL_VISIT_TASKS_B
2364: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2365:
2366: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Update_SR_Unit_Effectivity';
2367:

Line 2618: SELECT 'x' from AHL_VISIT_TASKS_B

2614: p_sr_ue_id IN NUMBER,
2615: p_defer_from_ue_id IN NUMBER) IS
2616:
2617: CURSOR get_tasks_for_ue_csr IS
2618: SELECT 'x' from AHL_VISIT_TASKS_B
2619: WHERE UNIT_EFFECTIVITY_ID = p_sr_ue_id;
2620:
2621: CURSOR get_all_ue_and_rel_ids_csr IS
2622: SELECT UE_RELATIONSHIP_ID, RELATED_UE_ID, LEVEL

Line 3003: SELECT 'x' from AHL_VISIT_TASKS_B

2999: x_status_changed OUT NOCOPY BOOLEAN,
3000: x_new_ue_status OUT NOCOPY AHL_UNIT_EFFECTIVITIES_B.STATUS_CODE%TYPE) IS
3001:
3002: CURSOR get_tasks_for_ue_csr IS
3003: SELECT 'x' from AHL_VISIT_TASKS_B
3004: where UNIT_EFFECTIVITY_ID = p_sr_ue_id;
3005:
3006: CURSOR get_rel_count_csr IS
3007: SELECT COUNT(*) FROM AHL_UE_RELATIONSHIPS

Line 3142: AHL_VISIT_TASKS_B VTSK,

3138: VST.visit_number
3139: FROM
3140: AHL_WORKORDERS WO,
3141: WIP_DISCRETE_JOBS WIPJ,
3142: AHL_VISIT_TASKS_B VTSK,
3143: AHL_VISITS_B VST,
3144: AHL_UNIT_EFFECTIVITIES_B UE
3145: WHERE
3146: WO.status_code not in (4,12,7,5) AND -- Completed/Closed/Cancelled/Completed_No_Charge