APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_MR_ROUTES

Line 334: FROM AHL_MR_ROUTES A

330: ATTRIBUTE13,
331: ATTRIBUTE14,
332: ATTRIBUTE15,
333: STAGE
334: FROM AHL_MR_ROUTES A
335: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID
336: AND ROUTE_ID IN (SELECT ROUTE_ID
337: FROM AHL_ROUTES_B
338: WHERE ROUTE_ID=A.ROUTE_ID

Line 378: FROM AHL_MR_ROUTES A

374: FROM AHL_MR_ROUTE_SEQUENCES C
375: WHERE MR_ROUTE_ID=C_MR_ROUTE_ID
376: AND EXISTS
377: (SELECT MR_ROUTE_ID
378: FROM AHL_MR_ROUTES A
379: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID
380: AND MR_ROUTE_ID=C.RELATED_MR_ROUTE_ID
381: AND ROUTE_ID IN (SELECT ROUTE_ID
382: FROM AHL_ROUTES_B

Line 922: AHL_MR_ROUTES_PKG.INSERT_ROW (

918:
919:
920: l_old_mr_route_id:=l_mr_route_Rec.mr_route_id;
921:
922: AHL_MR_ROUTES_PKG.INSERT_ROW (
923: X_MR_ROUTE_ID =>l_new_mr_ROUTE_ID,
924: X_STAGE =>l_mr_route_rec.STAGE,
925: X_OBJECT_VERSION_NUMBER =>1,
926: X_MR_HEADER_ID =>x_new_mr_header_id,

Line 1934: FROM AHL_MR_ROUTES A

1930: Close GetHeaderInfo1;
1931: End if;
1932:
1933: SELECT COUNT(*) INTO l_counter
1934: FROM AHL_MR_ROUTES A
1935: WHERE MR_HEADER_ID=l_activity_id
1936: AND ROUTE_ID IN (SELECT ROUTE_ID FROM AHL_ROUTES_APP_V
1937: WHERE ROUTE_ID=A.ROUTE_id
1938: AND NVL(END_DATE_ACTIVE,SYSDATE+1)>SYSDATE