DBA Data[Home] [Help]

APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_PROJ_STRUCTURE_TYPES

Line 2736: pa_proj_structure_types ppst,

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,
2740: pa_proj_structure_types ppst1

Line 2740: pa_proj_structure_types ppst1

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
2744: -- **** Added for bug 13108355

Line 2769: pa_proj_structure_types ppst,

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,
2773: pa_proj_structure_types ppst1

Line 2773: pa_proj_structure_types ppst1

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
2777: -- **** Added for bug 13108355