DBA Data[Home] [Help]

APPS.PA_PPR_ROLLUP_PERIOD_PVT dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 882: pa_proj_elem_ver_structure s,

878: select /*+ ordered */ distinct decode(bud.fin_plan_type_id,10,'WORKPLAN','FINANCIAL') ,
879: s.element_version_id, s.proj_element_id
880: into l_version_type , l_struct_ver_id , l_struct_elem_id
881: from pa_budget_versions bud,
882: pa_proj_elem_ver_structure s,
883: pa_proj_structure_types ppst,
884: pa_structure_types pst
885: where
886: bud.budget_version_id = l_budget_version_id

Line 901: pa_proj_elem_ver_structure s,

897: select /*+ ordered */
898: distinct 0, s.proj_element_id
899: into l_struct_ver_id , l_struct_elem_id
900: from
901: pa_proj_elem_ver_structure s,
902: pa_proj_structure_types ppst,
903: pa_structure_types pst
904: where
905: s.project_id = l_project_id