APPS.OKE_ALLOCATION_PVT dependencies on PA_FIN_STRUCTURES_LINKS_V

Line 639: from pa_fin_structures_links_v

635: select 'x'
636: from dual
637: where p_project_id in
638: (select to_number(sub_project_id)
639: from pa_fin_structures_links_v
640: start with parent_project_id = x_project_id
641: connect by parent_project_id = prior sub_project_id
642: );
643:

Line 649: from pa_fin_structures_links_v

645: select 'x'
646: from dual
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))

Line 820: from pa_fin_structures_links_v

816: select 'x'
817: from dual
818: where p_project_id in
819: (select to_number(sub_project_id)
820: from pa_fin_structures_links_v
821: start with parent_project_id = x_project_id
822: connect by parent_project_id = prior sub_project_id
823: union all
824: select x_project_id

Line 833: from pa_fin_structures_links_v

829: select 'x'
830: from dual
831: where p_project_id in
832: ( select to_number(sub_project_id)
833: from pa_fin_structures_links_v
834: start with parent_project_id = x_project_id
835: and parent_task_id = x_task_id
836: connect by parent_project_id = prior sub_project_id
837: union all