APPS.AHL_VWP_RULES_PVT dependencies on AHL_ROUTES_B_KFV

Line 4297: FROM ahl_visit_tasks_b tsk, ahl_routes_b route, ahl_routes_b_kfv kfv, ahl_mr_routes mrt

4293: SELECT route.route_no,
4294: route.route_type_code,
4295: kfv.concatenated_segments,
4296: route.process_code
4297: FROM ahl_visit_tasks_b tsk, ahl_routes_b route, ahl_routes_b_kfv kfv, ahl_mr_routes mrt
4298: WHERE tsk.mr_route_id = mrt.mr_route_id
4299: AND mrt.route_id = route.route_id
4300: AND tsk.visit_task_id = p_task_id
4301: AND kfv.route_id = route.route_id;

Line 4323: FROM ahl_visit_tasks_b tsk, ahl_routes_b route, ahl_routes_b_kfv kfv, ahl_mr_routes assoc

4319:
4320: --To match the post route attributes with the route attributes of all the tasks that fall under the same stage.
4321: Cursor get_task_id (p_stage_id IN NUMBER, p_route_no IN VARCHAR2, p_route_type IN VARCHAR2, p_system_code IN VARCHAR2, p_process_code IN VARCHAR2) IS
4322: SELECT tsk.visit_task_id, tsk.visit_task_number
4323: FROM ahl_visit_tasks_b tsk, ahl_routes_b route, ahl_routes_b_kfv kfv, ahl_mr_routes assoc
4324: WHERE kfv.route_id = route.route_id
4325: AND NVL2(p_route_no, route.ROUTE_NO,'X') = NVL(p_route_no, 'X')
4326: AND NVL2(p_route_type,route.ROUTE_TYPE_CODE,'X') = NVL(p_route_type, 'X')
4327: AND NVL2(p_system_code,kfv.CONCATENATED_SEGMENTS,'X') = NVL(p_system_code, 'X')