52: SELECT
53: T.TASK_ID
54: INTO P_TASK_ID
55: FROM
56: PA_TASKS T
57: WHERE PROJECT_ID = PROJ
58: AND DECODE(C_TOP_TASK_ID
59: ,''
60: ,T.PARENT_TASK_ID
98: TASK_NAME,
99: TASK_NUMBER
100: INTO P_TASK_NAME,P_TASK_NUMBER
101: FROM
102: PA_TASKS
103: WHERE TASK_ID = C_TOP_TASK_ID;
104: C_TASK_NAME := P_TASK_NAME;
105: C_TASK_NUMBER := P_TASK_NUMBER;
106: END IF;