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 821: from pa_fin_structures_links_v

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

Line 838: from pa_fin_structures_links_v a

834: select 'x'
835: from dual
836: where x_project_id in
837: (select a.parent_project_id
838: from pa_fin_structures_links_v a
839: start with sub_project_id = p_project_id
840: connect by sub_project_id = prior parent_project_id
841: union all
842: select p_project_id

Line 852: from pa_fin_structures_links_v

848: select 'x'
849: from dual
850: where p_project_id in
851: ( select to_number(sub_project_id)
852: from pa_fin_structures_links_v
853: start with parent_project_id = x_project_id
854: and parent_task_id = x_task_id
855: connect by parent_project_id = prior sub_project_id
856: union all

Line 869: from pa_fin_structures_links_v a

865: select 'x'
866: from dual
867: where (x_project_id,x_task_id) in
868: ( select a.parent_project_id,a.parent_task_id
869: from pa_fin_structures_links_v a
870: start with sub_project_id = p_project_id
871: connect by sub_project_id = prior parent_project_id
872: union all
873: select p_project_id,x_task_id