APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_STRUCT_TASK_WBS_V

Line 6365: FROM pa_struct_task_wbs_v

6361:
6362: BEGIN
6363: SELECT project_id
6364: INTO l_project_id
6365: FROM pa_struct_task_wbs_v
6366: WHERE parent_Structure_version_id=p_struct_elem_version_id
6367: AND ROWNUM=1;
6368: EXCEPTION
6369: WHEN NO_DATA_FOUND THEN

Line 8520: FROM pa_struct_task_wbs_v pt,

8516: --dbms_output.put_line('in copy plan txn2');
8517: --Derive the plan version id for the source and target element version ids
8518: SELECT pbv.budget_version_id
8519: INTO l_src_budget_version_id
8520: FROM pa_struct_task_wbs_v pt,
8521: pa_budget_versions pbv
8522: WHERE pbv.project_structure_version_id= pt.parent_structure_version_id
8523: AND pt.element_version_id=p_src_version_id_tbl(1)
8524: AND pbv.wp_version_flag='Y';

Line 8536: ,pa_struct_task_wbs_v pt

8532: --dbms_output.put_line('in copy plan txn2.5');
8533: SELECT pbv.budget_version_id
8534: INTO l_targ_budget_version_id
8535: FROM pa_budget_versions pbv
8536: ,pa_struct_task_wbs_v pt
8537: WHERE pt.element_version_id=p_targ_version_id_tbl(1)
8538: AND pbv.project_structure_version_id=pt.parent_structure_version_id
8539: AND pbv.wp_version_flag='Y';
8540:

Line 12214: from pa_struct_task_wbs_v v

12210: version_info_rec version_info_cur%ROWTYPE;
12211:
12212: CURSOR lowest_tasks_cur (c_parent_structure_version_id number) is
12213: select v.element_version_id
12214: from pa_struct_task_wbs_v v
12215: where v.parent_structure_version_id = c_parent_structure_version_id
12216: and v.financial_task_flag = 'Y' -- raja bug 3690418
12217: and v.task_level = 'L'
12218: and not exists (select 'x'

Line 12227: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.

12223:
12224: CURSOR top_tasks_cur (c_project_id number, c_parent_structure_version_id number) is
12225: select b.element_version_id
12226: from pa_tasks a, pa_proj_element_versions b
12227: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
12228: * Note that financial_task_flag of pa_proj_element_versions cannot be used
12229: * since it is set to Y even for tasks that are part of fin struct ver but not
12230: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This
12231: * required a join with pa_tasks to identify true fin tasks which can be