[Home] [Help]
4312: FROM dual
4313: WHERE
4314: EXISTS (SELECT 'X'
4315: FROM pa_pt_co_impl_statuses ptco,
4316: pa_ci_statuses_v pcs
4317: WHERE ptco.ci_type_id = p_ci_type_id
4318: AND ptco.version_type = p_version_type
4319: AND ptco.ci_type_id = pcs.ci_type_id
4320: AND ptco.status_code=pcs.project_status_code
4763: working version should be considered. */
4764: /* commented by Raja rewritten the cursor below
4765: CURSOR c_change_documents_status
4766: (c_project_id pa_projects_all.project_id%TYPE,
4767: c_system_status_code pa_ci_statuses_v.project_system_status_code%TYPE,
4768: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE) IS
4769: SELECT nvl(sum(pfca.people_effort),0),
4770: nvl(sum(pfca.equipment_effort),0),
4771: nvl(sum(decode(c_margin_derived_from_code,'B',
4784: -- Bug 3947153. Modified the inner select for revenue data to show the correct quantity. Please see
4785: -- the bug for details
4786: CURSOR c_change_documents_status
4787: (c_project_id pa_projects_all.project_id%TYPE,
4788: c_system_status_code pa_ci_statuses_v.project_system_status_code%TYPE,
4789: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4790: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
4791: c_appr_rev_cw_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS -- Raja review
4792: SELECT (cost_query.people_effort + revenue_query.people_effort),
7091: --Any cursor change may be required to be incorporated in PaFpCiIncludeChangeOrderVO.xml as well.
7092: --Changed this cursor for bug 3902176
7093:
7094: CURSOR c_change_documents_status(
7095: c_system_status_code PA_CI_STATUSES_V.PROJECT_SYSTEM_STATUS_CODE%TYPE,
7096: c_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7097: c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
7098: c_fin_plan_type_id PA_BUDGET_VERSIONS.FIN_PLAN_TYPE_ID%TYPE,
7099: c_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS