DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_PVT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 1102: pa_proj_elem_ver_structure s,

1098: select /*+ ordered */ distinct decode(bud.fin_plan_type_id,10,'WORKPLAN','FINANCIAL') ,
1099: s.element_version_id, s.proj_element_id
1100: into l_version_type , l_struct_ver_id , l_struct_elem_id
1101: from pa_budget_versions bud,
1102: pa_proj_elem_ver_structure s,
1103: pa_proj_structure_types ppst,
1104: pa_structure_types pst
1105: where
1106: bud.budget_version_id = l_budget_version_id

Line 1121: pa_proj_elem_ver_structure s,

1117: select /*+ ordered */
1118: distinct 0, s.proj_element_id
1119: into l_struct_ver_id , l_struct_elem_id
1120: from
1121: pa_proj_elem_ver_structure s,
1122: pa_proj_structure_types ppst,
1123: pa_structure_types pst
1124: where
1125: s.project_id = l_project_id