DBA Data[Home] [Help]

APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJ_WORKPLAN_ATTR

Line 2735: pa_proj_workplan_attr ppwa,

2731: --select working verisons from versioned projects
2732: SELECT a.project_id, a.element_version_id, a.prg_level
2733: FROM pa_proj_element_versions a,
2734: pa_proj_elem_ver_structure b,
2735: pa_proj_workplan_attr ppwa,
2736: pa_proj_structure_types ppst,
2737: pa_proj_element_versions c,
2738: pa_proj_elem_ver_structure b1,
2739: pa_proj_workplan_attr ppwa1,

Line 2739: pa_proj_workplan_attr ppwa1,

2735: pa_proj_workplan_attr ppwa,
2736: pa_proj_structure_types ppst,
2737: pa_proj_element_versions c,
2738: pa_proj_elem_ver_structure b1,
2739: pa_proj_workplan_attr ppwa1,
2740: pa_proj_structure_types ppst1
2741: WHERE
2742: c.project_id = p_project_id
2743: AND c.prg_group = a.prg_group

Line 2768: pa_proj_workplan_attr ppwa,

2764: --select published verisons from non-versioned projects
2765: SELECT a.project_id, a.element_version_id, a.prg_level
2766: FROM pa_proj_element_versions a,
2767: pa_proj_elem_ver_structure b,
2768: pa_proj_workplan_attr ppwa,
2769: pa_proj_structure_types ppst,
2770: pa_proj_element_versions c,
2771: pa_proj_elem_ver_structure b1,
2772: pa_proj_workplan_attr ppwa1,

Line 2772: pa_proj_workplan_attr ppwa1,

2768: pa_proj_workplan_attr ppwa,
2769: pa_proj_structure_types ppst,
2770: pa_proj_element_versions c,
2771: pa_proj_elem_ver_structure b1,
2772: pa_proj_workplan_attr ppwa1,
2773: pa_proj_structure_types ppst1
2774: WHERE
2775: c.project_id = p_project_id
2776: AND c.prg_group = a.prg_group