APPS.AHL_LTP_RESRC_LEVL_PVT dependencies on AHL_MR_ROUTES_APP_V

Line 2382: FROM ahl_visit_tasks_b a, ahl_mr_routes_app_v B

2378: ) IS
2379:
2380: CURSOR l_get_route_csr(p_task_id IN NUMBER) IS
2381: SELECT a.MR_ROUTE_ID,B.route_id
2382: FROM ahl_visit_tasks_b a, ahl_mr_routes_app_v B
2383: WHERE VISIT_TASK_ID = p_task_id
2384: AND a.mr_route_id = B.mr_route_id;
2385:
2386: CURSOR l_get_dept_csr(p_task_id IN NUMBER) IS

Line 2803: SELECT ROUTE_ID FROM ahl_mr_routes_app_v

2799: )
2800: ORDER BY RO.STEP;
2801:
2802: CURSOR l_get_route_id(p_mr_route_id IN NUMBER) IS
2803: SELECT ROUTE_ID FROM ahl_mr_routes_app_v
2804: WHERE MR_ROUTE_ID = p_mr_route_id;
2805:
2806: -- get resources associated to route
2807: CURSOR l_rt_resource_dtl_csr (l_route_id IN NUMBER,

Line 3921: SELECT route_id FROM ahl_mr_routes_app_v

3917: x_duration OUT NOCOPY NUMBER
3918: ) IS
3919:
3920: CURSOR l_route_csr (p_route_id IN NUMBER) IS
3921: SELECT route_id FROM ahl_mr_routes_app_v
3922: WHERE mr_route_id = p_route_id;
3923:
3924: CURSOR l_route_time_span_csr (p_route_id IN NUMBER) IS
3925: SELECT NVL(time_span, 0) FROM ahl_routes_b