DBA Data[Home] [Help]

APPS.PA_ALLOC_UTILS dependencies on PA_TASKS

Line 164: from pa_tasks

160: IS
161: /***
162: CURSOR C_subtasks is
163: select task_id
164: from pa_tasks
165: CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
166: START WITH TASK_ID = p_task_id;
167: ***/
168:

Line 314: FROM pa_tasks

310: WHERE RSRC.task_id=p_task_id);
311:
312: CURSOR C_top_task(p_tsk_id IN NUMBER) IS
313: SELECT top_task_id
314: FROM pa_tasks
315: WHERE task_id=p_tsk_id;
316:
317:
318: v_ret_code varchar2(1) ;