APPS.AHL_RM_APPROVAL_PVT dependencies on AHL_MR_ROUTE_SEQUENCES_S

Line 1297: SELECT AHL_MR_ROUTE_SEQUENCES_S .NEXTVAL

1293: LOOP
1294: FETCH CurGetRouteSeqDet INTO l_mr_route_seq_rec;
1295: IF CurGetRouteSeqDet%FOUND
1296: THEN
1297: SELECT AHL_MR_ROUTE_SEQUENCES_S .NEXTVAL
1298: INTO l_new_mr_ROUTE_SEQ_ID FROM DUAL;
1299: IF l_mr_route_seq_rec.mr_route_id=l_old_mr_route_id
1300: THEN
1301: l_seq_rel_mr_route_id:=l_mr_route_seq_rec.related_mr_route_id;