APPS.AHL_FMP_MR_ROUTE_PVT dependencies on AHL_ROUTES_B

Line 282: ahl_routes_b

278: SELECT
279: route_id,
280: revision_status_code
281: FROM
282: ahl_routes_b
283: WHERE
284: UPPER(route_no)=UPPER(c_route_no) AND
285: revision_number=NVL(c_revision_number,revision_number) AND
286: TRUNC(NVL(end_date_active,SYSDATE+1))>TRUNC(SYSDATE) AND

Line 380: ahl_routes_b

376: --AMSRINIV : Bug 4913924 . Below commented query tuned.
377: SELECT
378: COUNT(*) into l_counter
379: FROM
380: ahl_routes_b
381: WHERE
382: route_no=p_x_mr_route_rec.route_number AND
383: revision_status_code='COMPLETE' AND
384: NVL(end_date_active,SYSDATE+1)>SYSDATE AND