APPS.AHL_FMP_MR_ROUTE_PVT dependencies on AHL_ROUTES_B

Line 262: ahl_routes_b

258: SELECT
259: route_id,
260: revision_status_code
261: FROM
262: ahl_routes_b
263: WHERE
264: UPPER(route_no)=UPPER(c_route_no) AND
265: revision_number=NVL(c_revision_number,revision_number) AND
266: TRUNC(NVL(end_date_active,SYSDATE+1))>TRUNC(SYSDATE) AND

Line 355: ahl_routes_b

351: --AMSRINIV : Bug 4913924 . Below commented query tuned.
352: SELECT
353: COUNT(*) into l_counter
354: FROM
355: ahl_routes_b
356: WHERE
357: route_no=p_mr_route_rec.route_number AND
358: revision_status_code='COMPLETE' AND
359: NVL(end_date_active,SYSDATE+1)>SYSDATE AND