DBA Data[Home] [Help]

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_PROJ_ELEM_VER_STRUCTURE

Line 4228: pa_proj_elem_ver_structure ver

4224:
4225: CURSOR last_published_wp_version_cur IS
4226: select bv.budget_version_id
4227: from pa_budget_versions bv,
4228: pa_proj_elem_ver_structure ver
4229: where bv.project_id = p_target_project_id
4230: and bv.wp_version_flag = 'Y'
4231: and bv.project_id = ver.project_id
4232: and bv.project_structure_version_id = ver.element_version_id

Line 4238: pa_proj_elem_ver_structure ver

4234:
4235: CURSOR baselined_wp_version_cur IS
4236: select bv.budget_version_id
4237: from pa_budget_versions bv,
4238: pa_proj_elem_ver_structure ver
4239: where bv.project_id = p_target_project_id
4240: and bv.wp_version_flag = 'Y'
4241: and bv.project_id = ver.project_id
4242: and bv.project_structure_version_id = ver.element_version_id

Line 4248: pa_proj_elem_ver_structure ver

4244:
4245: CURSOR current_working_wp_version_cur IS
4246: select bv.budget_version_id
4247: from pa_budget_versions bv,
4248: pa_proj_elem_ver_structure ver
4249: where bv.project_id = p_target_project_id
4250: and bv.wp_version_flag = 'Y'
4251: and bv.project_id = ver.project_id
4252: and bv.project_structure_version_id = ver.element_version_id