APPS.AHL_RM_APPROVAL_PVT dependencies on DUAL

Line 1200: FROM DUAL;

1196: THEN
1197:
1198: SELECT AHL_MR_ROUTES_S.NEXTVAL
1199: INTO l_new_mr_ROUTE_ID
1200: FROM DUAL;
1201:
1202: l_old_mr_route_id:=l_mr_route_Rec.mr_route_id;
1203:
1204: AHL_MR_ROUTES_PKG.INSERT_ROW (

Line 1238: INTO l_new_mr_ROUTE_SEQ_ID FROM DUAL;

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