APPS.AHL_WARRANTY_ENTL_PVT dependencies on AHL_MR_ROUTES

Line 255: AHL_MR_ROUTES MRR,

251: -- cursor to check for warranty template at 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