APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_STRUCT_TASK_WBS_V

Line 5696: FROM pa_struct_task_wbs_v

5692:
5693: BEGIN
5694: SELECT project_id
5695: INTO l_project_id
5696: FROM pa_struct_task_wbs_v
5697: WHERE parent_Structure_version_id=p_struct_elem_version_id
5698: AND ROWNUM=1;
5699: EXCEPTION
5700: WHEN NO_DATA_FOUND THEN

Line 7694: FROM pa_struct_task_wbs_v pt,

7690: --dbms_output.put_line('in copy plan txn2');
7691: --Derive the plan version id for the source and target element version ids
7692: SELECT pbv.budget_version_id
7693: INTO l_src_budget_version_id
7694: FROM pa_struct_task_wbs_v pt,
7695: pa_budget_versions pbv
7696: WHERE pbv.project_structure_version_id= pt.parent_structure_version_id
7697: AND pt.element_version_id=p_src_version_id_tbl(1)
7698: AND pbv.wp_version_flag='Y';

Line 7710: ,pa_struct_task_wbs_v pt

7706: --dbms_output.put_line('in copy plan txn2.5');
7707: SELECT pbv.budget_version_id
7708: INTO l_targ_budget_version_id
7709: FROM pa_budget_versions pbv
7710: ,pa_struct_task_wbs_v pt
7711: WHERE pt.element_version_id=p_targ_version_id_tbl(1)
7712: AND pbv.project_structure_version_id=pt.parent_structure_version_id
7713: AND pbv.wp_version_flag='Y';
7714:

Line 11340: from pa_struct_task_wbs_v v

11336: version_info_rec version_info_cur%ROWTYPE;
11337:
11338: CURSOR lowest_tasks_cur (c_parent_structure_version_id number) is
11339: select v.element_version_id
11340: from pa_struct_task_wbs_v v
11341: where v.parent_structure_version_id = c_parent_structure_version_id
11342: and v.financial_task_flag = 'Y' -- raja bug 3690418
11343: and v.task_level = 'L'
11344: and not exists (select 'x'

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

11349:
11350: CURSOR top_tasks_cur (c_project_id number, c_parent_structure_version_id number) is
11351: select b.element_version_id
11352: from pa_tasks a, pa_proj_element_versions b
11353: /* Replaced pa_struct_task_wbs_v with base tables for performance reasons.
11354: * Note that financial_task_flag of pa_proj_element_versions cannot be used
11355: * since it is set to Y even for tasks that are part of fin struct ver but not
11356: * yet published. (I.e., It could be Y for tasks not present in pa_tasks too). This
11357: * required a join with pa_tasks to identify true fin tasks which can be