APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_MR_ROUTE_SEQUENCES_S

Line 1237: SELECT AHL_MR_ROUTE_SEQUENCES_S .NEXTVAL

1233: LOOP
1234: FETCH CurGetRouteSeqDet INTO l_mr_route_seq_rec;
1235: IF CurGetRouteSeqDet%FOUND
1236: THEN
1237: SELECT AHL_MR_ROUTE_SEQUENCES_S .NEXTVAL
1238: INTO l_new_mr_ROUTE_SEQ_ID FROM DUAL;
1239: IF l_mr_route_seq_rec.mr_route_id=l_old_mr_route_id
1240: THEN
1241: l_seq_rel_mr_route_id:=l_mr_route_seq_rec.related_mr_route_id;