APPS.AHL_UMP_FORECAST_REQ_PVT dependencies on AHL_VISIT_TASKS_B

Line 172: FROM ahl_visit_tasks_b

168: -- Added by SURRKUMA for Service Bulletin on 17-Jun-11
169: -- Fetches the Visit ID for the given ue_id
170: CURSOR get_visit_id_csr(p_unit_effectivity_id IN NUMBER) IS
171: SELECT DISTINCT visit_id
172: FROM ahl_visit_tasks_b
173: WHERE unit_effectivity_id = p_unit_effectivity_id;
174:
175: l_Schedule_Mtl_Req_rec AHL_SCHEDULE_MATERIALS%ROWTYPE;
176:

Line 1067: FROM ahl_visit_tasks_b

1063: -- Added by SURRKUMA for Service Bulletin on 17-Jun-11
1064: -- Fetches the Visit ID for the given ue_id
1065: CURSOR get_visit_id_csr(p_unit_effectivity_id IN NUMBER) IS
1066: SELECT DISTINCT visit_id
1067: FROM ahl_visit_tasks_b
1068: WHERE unit_effectivity_id = p_unit_effectivity_id;
1069:
1070: l_debug_module VARCHAR2(1000) := 'ahl.plsql.AHL_UMP_FORECAST_REQ_PVT.Process_Material_Req';
1071: l_Schedule_Mtl_Req_rec AHL_SCHEDULE_MATERIALS%ROWTYPE;