APPS.PA_FP_CONTROL_ITEMS_UTILS dependencies on PA_CI_TYPES_VL

Line 4764: ,pa_ci_types_vl pct

4760: ,PBV.TOTAL_PROJECT_BURDENED_COST AS BURDENED_COST
4761: FROM pa_budget_versions pbv
4762: ,pa_control_items pci
4763: ,pa_project_statuses pcs
4764: ,pa_ci_types_vl pct
4765: WHERE PBV.CI_ID = PCI.CI_ID
4766: AND PBV.PROJECT_ID = PCI.PROJECT_ID
4767: AND PCI.STATUS_CODE = PCS.PROJECT_STATUS_CODE
4768: AND pct.ci_type_id = pci.ci_type_id

Line 4828: ,pa_ci_types_vl pct

4824: ,nvl(PBV.REV_PARTIALLY_IMPL_FLAG,'N') AS REV_PARTIALLY_IMPL_FLAG
4825: FROM pa_budget_versions pbv
4826: ,pa_control_items pci
4827: ,pa_project_statuses pcs
4828: ,pa_ci_types_vl pct
4829: WHERE PBV.CI_ID = PCI.CI_ID
4830: AND PBV.PROJECT_ID = PCI.PROJECT_ID
4831: AND PCI.STATUS_CODE = PCS.PROJECT_STATUS_CODE
4832: AND pct.ci_type_id = pci.ci_type_id

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

9141: x_plan_class_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9142: x_report_cost_using OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9143: x_cost_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9144: x_rev_impl_into_app_cw_ver OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9145: x_ci_type OUT NOCOPY pa_ci_types_vl.name%TYPE, --File.Sql.39 bug 4440895
9146: x_ci_number OUT NOCOPY pa_control_items.ci_number%TYPE, --File.Sql.39 bug 4440895
9147: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9148: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9149: x_return_status OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 9478: FROM pa_control_items ci,pa_ci_types_vl ct

9474: --For bug 3957561
9475:
9476: SELECT ci.ci_number,ct.name
9477: INTO x_ci_number,x_ci_type
9478: FROM pa_control_items ci,pa_ci_types_vl ct
9479: WHERE ci_id=p_ci_id
9480: AND ci.ci_type_id=ct.ci_type_id;
9481:
9482: IF l_debug_mode = 'Y' THEN