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 318: FROM pa_tasks

314: WHERE RSRC.task_id=p_task_id);
315:
316: CURSOR C_top_task(p_tsk_id IN NUMBER) IS
317: SELECT top_task_id
318: FROM pa_tasks
319: WHERE task_id=p_tsk_id;
320:
321:
322: v_ret_code varchar2(1) ;