[Home] [Help]
4263: FROM dual
4264: WHERE
4265: EXISTS (SELECT 'X'
4266: FROM pa_pt_co_impl_statuses ptco,
4267: pa_ci_statuses_v pcs
4268: WHERE ptco.ci_type_id = p_ci_type_id
4269: AND ptco.version_type = p_version_type
4270: AND ptco.ci_type_id = pcs.ci_type_id
4271: AND ptco.status_code=pcs.project_status_code
4707: working version should be considered. */
4708: /* commented by Raja rewritten the cursor below
4709: CURSOR c_change_documents_status
4710: (c_project_id pa_projects_all.project_id%TYPE,
4711: c_system_status_code pa_ci_statuses_v.project_system_status_code%TYPE,
4712: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE) IS
4713: SELECT nvl(sum(pfca.people_effort),0),
4714: nvl(sum(pfca.equipment_effort),0),
4715: nvl(sum(decode(c_margin_derived_from_code,'B',
4728: -- Bug 3947153. Modified the inner select for revenue data to show the correct quantity. Please see
4729: -- the bug for details
4730: CURSOR c_change_documents_status
4731: (c_project_id pa_projects_all.project_id%TYPE,
4732: c_system_status_code pa_ci_statuses_v.project_system_status_code%TYPE,
4733: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4734: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
4735: c_appr_rev_cw_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS -- Raja review
4736: SELECT (cost_query.people_effort + revenue_query.people_effort),
7019: --Any cursor change may be required to be incorporated in PaFpCiIncludeChangeOrderVO.xml as well.
7020: --Changed this cursor for bug 3902176
7021:
7022: CURSOR c_change_documents_status(
7023: c_system_status_code PA_CI_STATUSES_V.PROJECT_SYSTEM_STATUS_CODE%TYPE,
7024: c_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7025: c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
7026: c_fin_plan_type_id PA_BUDGET_VERSIONS.FIN_PLAN_TYPE_ID%TYPE,
7027: c_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS