DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_ACTUAL_PVT dependencies on PA_PROJ_STRUCTURE_TYPES

Line 747: pa_proj_structure_types ppst,

743: select /*+ ordered */ distinct decode(bud.fin_plan_type_id,10,'WORKPLAN','FINANCIAL') , s.element_version_id
744: into l_version_type , l_struct_ver_id
745: from pa_budget_versions bud,
746: pa_proj_elem_ver_structure s,
747: pa_proj_structure_types ppst,
748: pa_structure_types pst
749: where
750: bud.budget_version_id = l_budget_version_id
751: and s.proj_element_id = ppst.proj_element_id (+)