28: SELECT
29: SEGMENT1
30: INTO P_FROM_PROJECT_NUMBER
31: FROM
32: PA_PROJECTS_ALL
33: WHERE PROJECT_ID = P_FROM_PROJECT_NUMBER;
34: END;
35: END IF;
36: IF P_TO_PROJECT_NUMBER IS NOT NULL THEN
38: SELECT
39: SEGMENT1
40: INTO P_TO_PROJECT_NUMBER
41: FROM
42: PA_PROJECTS_ALL
43: WHERE PROJECT_ID = P_TO_PROJECT_NUMBER;
44: END;
45: END IF;
46: IF P_PROJ_TYPE IS NOT NULL THEN