APPS.AHL_WARRANTY_ENTL_PVT dependencies on AHL_ROUTES_B

Line 256: AHL_ROUTES_B ROUTE

252: CURSOR chk_wrrnty_tmpl_route_csr (c_task_id NUMBER) IS
253: SELECT 'X'
254: FROM AHL_VISIT_TASKS_B TSK,
255: AHL_MR_ROUTES MRR,
256: AHL_ROUTES_B ROUTE
257: WHERE ROUTE.warranty_template_id IS NOT NULL
258: AND ROUTE.route_id = MRR.route_id
259: AND MRR.mr_route_id = TSK.mr_route_id
260: AND TSK.visit_task_id = c_task_id;