APPS.AHL_RM_APPROVAL_PVT dependencies on DUAL

Line 1258: FROM DUAL;

1254: THEN
1255:
1256: SELECT AHL_MR_ROUTES_S.NEXTVAL
1257: INTO l_new_mr_ROUTE_ID
1258: FROM DUAL;
1259:
1260: l_old_mr_route_id:=l_mr_route_Rec.mr_route_id;
1261:
1262: AHL_MR_ROUTES_PKG.INSERT_ROW (

Line 1298: INTO l_new_mr_ROUTE_SEQ_ID FROM DUAL;

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;
1302: l_seq_mr_route_id:=l_new_mr_ROUTE_ID;