APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_PROJECT_STATUSES

Line 4819: ,pa_project_statuses pcs

4815: ,PBV.TOTAL_PROJECT_RAW_COST AS RAW_COST
4816: ,PBV.TOTAL_PROJECT_BURDENED_COST AS BURDENED_COST
4817: FROM pa_budget_versions pbv
4818: ,pa_control_items pci
4819: ,pa_project_statuses pcs
4820: ,pa_ci_types_vl pct
4821: WHERE PBV.CI_ID = PCI.CI_ID
4822: AND PBV.PROJECT_ID = PCI.PROJECT_ID
4823: AND PCI.STATUS_CODE = PCS.PROJECT_STATUS_CODE

Line 4883: ,pa_project_statuses pcs

4879: ,PBV.TOTAL_PROJECT_REVENUE AS REVENUE
4880: ,nvl(PBV.REV_PARTIALLY_IMPL_FLAG,'N') AS REV_PARTIALLY_IMPL_FLAG
4881: FROM pa_budget_versions pbv
4882: ,pa_control_items pci
4883: ,pa_project_statuses pcs
4884: ,pa_ci_types_vl pct
4885: WHERE PBV.CI_ID = PCI.CI_ID
4886: AND PBV.PROJECT_ID = PCI.PROJECT_ID
4887: AND PCI.STATUS_CODE = PCS.PROJECT_STATUS_CODE

Line 9422: pa_project_statuses pps

9418: --Get the CI status code
9419: SELECT pps.project_system_status_code
9420: INTO x_ci_status_code
9421: FROM pa_control_items pci,
9422: pa_project_statuses pps
9423: WHERE pci.ci_id=p_ci_id
9424: AND pps.project_status_code=pci.status_code;
9425:
9426: --Derive the value for x_impact_in_mc_flag. This should be 'Y' if either COST or REVENUE impact is