APPS.OKE_ALLOCATION_PVT dependencies on PA_TASKS

Line 248: from pa_tasks

244: ) is
245:
246: cursor c_project_task is
247: select 'x'
248: from pa_tasks
249: where task_id = p_task_id
250: and top_task_id = p_task_id
251: and project_id = p_project_id;
252:

Line 651: IN (SELECT x_project_id, task_id FROM pa_tasks

647: where p_project_id in
648: ( select to_number(sub_project_id)
649: from pa_fin_structures_links_v
650: START WITH (parent_project_id, parent_task_id)
651: IN (SELECT x_project_id, task_id FROM pa_tasks
652: WHERE project_id = x_project_id
653: AND top_task_id = nvl(x_task_id, top_task_id))
654: connect by parent_project_id = prior sub_project_id);
655:

Line 1036: from pa_tasks

1032: p_return_status OUT NOCOPY VARCHAR2
1033: ) is
1034: cursor c_task_id is
1035: select 'x'
1036: from pa_tasks
1037: where task_id = p_task_id
1038: and task_id = top_task_id;
1039:
1040: l_dummy_value VARCHAR2(1) := '?';