APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_CI_TYPES_VL

Line 4820: ,pa_ci_types_vl pct

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
4824: AND pct.ci_type_id = pci.ci_type_id

Line 4884: ,pa_ci_types_vl pct

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
4888: AND pct.ci_type_id = pci.ci_type_id

Line 9303: x_ci_type OUT NOCOPY pa_ci_types_vl.name%TYPE, --File.Sql.39 bug 4440895

9299: x_plan_class_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9300: x_report_cost_using OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9301: x_cost_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9302: x_rev_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9303: x_ci_type OUT NOCOPY pa_ci_types_vl.name%TYPE, --File.Sql.39 bug 4440895
9304: x_ci_number OUT NOCOPY pa_control_items.ci_number%TYPE, --File.Sql.39 bug 4440895
9305: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9306: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9307: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 9636: FROM pa_control_items ci,pa_ci_types_vl ct

9632: --For bug 3957561
9633:
9634: SELECT ci.ci_number,ct.name
9635: INTO x_ci_number,x_ci_type
9636: FROM pa_control_items ci,pa_ci_types_vl ct
9637: WHERE ci_id=p_ci_id
9638: AND ci.ci_type_id=ct.ci_type_id;
9639:
9640: IF l_debug_mode = 'Y' THEN