APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_MR_HEADERS_B

Line 856: from ahl_mr_routes a, ahl_mr_headers_b b

852: AND trunc(nvl(AHL_ROUTE_MR_V.EFFECTIVE_TO,SYSDATE))>=trunc(SYSDATE);*/
853:
854: --AMSRINIV : Bug 4913294. Tuned above commented query.
855: SELECT COUNT(*) into l_counter
856: from ahl_mr_routes a, ahl_mr_headers_b b
857: where
858: a.route_id = l_route_rec.route_id and
859: a.mr_header_id = b.mr_header_id and
860: b.application_usg_code = rtrim(ltrim(fnd_profile.value('AHL_APPLN_USAGE'))) and