APPS.OKE_CLE_PVT dependencies on PA_FIN_STRUCTURES_LINKS_V

Line 268: from pa_fin_structures_links_v

264: select p.project_id pid,p.segment1
265: from pa_projects_all p
266: where p.project_id in
267: (select to_number(sub_project_id) project_id
268: from pa_fin_structures_links_v
269: start with parent_project_id = l_project_id_from
270: and parent_task_id in (select task_id from pa_tasks where project_id=l_project_id_from
271: and top_task_id=nvl(l_task_id_from,top_task_id) )
272: connect by parent_project_id = prior sub_project_id)

Line 290: from pa_fin_structures_links_v

286: WHERE pid = p_cle_rec.PROJECT_ID;
287:
288: cursor c_z(x_proj number, x_task number) is /* check is only needed if task is specified as well */
289: select 'x'
290: from pa_fin_structures_links_v
291: start with ((parent_project_id = x_proj ) and parent_task_id in
292: (select task_id from pa_tasks
293: where project_id = x_proj
294: and top_task_id = nvl(x_task, top_task_id)))