DBA Data[Home] [Help]

APPS.PA_ASSET_ALLOCATION_PVT dependencies on PA_TASKS

Line 86: FROM pa_tasks

82:
83: CURSOR wbs_branch_tasks_cur(x_parent_task_id NUMBER) IS
84: SELECT task_id,
85: task_number
86: FROM pa_tasks
87: WHERE task_id <> x_parent_task_id
88: AND task_id <> p_task_id
89: CONNECT BY parent_task_id = PRIOR task_id
90: START WITH task_id = x_parent_task_id;

Line 226: FROM pa_tasks

222: SELECT top_task_id,
223: parent_task_id
224: INTO v_top_task_id,
225: v_parent_task_id
226: FROM pa_tasks
227: WHERE task_id = p_task_id;
228:
229:
230: IF PG_DEBUG = 'Y' THEN