APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_MR_HEADERS_B

Line 798: from ahl_mr_routes a, ahl_mr_headers_b b

794: AND trunc(nvl(AHL_ROUTE_MR_V.EFFECTIVE_TO,SYSDATE))>=trunc(SYSDATE);*/
795:
796: --AMSRINIV : Bug 4913294. Tuned above commented query.
797: SELECT COUNT(*) into l_counter
798: from ahl_mr_routes a, ahl_mr_headers_b b
799: where
800: a.route_id = l_route_rec.route_id and
801: a.mr_header_id = b.mr_header_id and
802: b.application_usg_code = rtrim(ltrim(fnd_profile.value('AHL_APPLN_USAGE'))) and