APPS.AHL_FMP_MR_REVISION_PVT dependencies on AHL_MR_ROUTES

Line 326: FROM AHL_MR_ROUTES A

322: ATTRIBUTE13,
323: ATTRIBUTE14,
324: ATTRIBUTE15,
325: STAGE
326: FROM AHL_MR_ROUTES A
327: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID
328: AND ROUTE_ID IN (SELECT ROUTE_ID
329: FROM AHL_ROUTES_B
330: WHERE ROUTE_ID=A.ROUTE_ID

Line 370: FROM AHL_MR_ROUTES A

366: FROM AHL_MR_ROUTE_SEQUENCES C
367: WHERE MR_ROUTE_ID=C_MR_ROUTE_ID
368: AND EXISTS
369: (SELECT MR_ROUTE_ID
370: FROM AHL_MR_ROUTES A
371: WHERE MR_HEADER_ID=P_SOURCE_MR_HEADER_ID
372: AND MR_ROUTE_ID=C.RELATED_MR_ROUTE_ID
373: AND ROUTE_ID IN (SELECT ROUTE_ID
374: FROM AHL_ROUTES_B

Line 770: AHL_MR_ROUTES_PKG.INSERT_ROW (

766:
767:
768: l_old_mr_route_id:=l_mr_route_Rec.mr_route_id;
769:
770: AHL_MR_ROUTES_PKG.INSERT_ROW (
771: X_MR_ROUTE_ID =>l_new_mr_ROUTE_ID,
772: X_STAGE =>l_mr_route_rec.STAGE,
773: X_OBJECT_VERSION_NUMBER =>1,
774: X_MR_HEADER_ID =>x_new_mr_header_id,

Line 1540: FROM AHL_MR_ROUTES A

1536: Close GetHeaderInfo1;
1537: End if;
1538:
1539: SELECT COUNT(*) INTO l_counter
1540: FROM AHL_MR_ROUTES A
1541: WHERE MR_HEADER_ID=l_activity_id
1542: AND ROUTE_ID IN (SELECT ROUTE_ID FROM AHL_ROUTES_APP_V
1543: WHERE ROUTE_ID=A.ROUTE_id
1544: AND NVL(END_DATE_ACTIVE,SYSDATE+1)>SYSDATE