DBA Data[Home] [Help]

APPS.PA_PLANNING_ELEMENT_UTILS dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 43: pa_proj_elem_ver_structure evs

39: -- join with pa_budget_versions
40: select evs.element_version_id -- changed by shyugen
41: into l_wp_structure_version_id
42: from pa_proj_element_versions ev,
43: pa_proj_elem_ver_structure evs
44: where ev.project_id = p_project_id and
45: ev.element_version_id = p_element_version_id and
46: ev.project_id = evs.project_id and -- Added for perf fix - 3961665
47: ev.parent_structure_version_id = evs.element_version_id;

Line 75: from pa_proj_elem_ver_structure str,

71: -- RETRIEVE CURRENT BASELINED VERSION ID
72: begin
73: select bv.budget_version_id
74: into x_baselined_version_id
75: from pa_proj_elem_ver_structure str,
76: pa_proj_element_versions ppev1,
77: pa_proj_element_versions ppev2,
78: pa_budget_versions bv
79: where ppev1.element_version_id = p_element_version_id

Line 95: from pa_proj_elem_ver_structure str,

91: -- RETRIEVE LATEST PUBLISHED VERSION ID
92: begin
93: select bv.budget_version_id
94: into x_published_version_id
95: from pa_proj_elem_ver_structure str,
96: pa_proj_element_versions ppev1,
97: pa_proj_element_versions ppev2,
98: pa_budget_versions bv
99: where ppev1.element_version_id = p_element_version_id