531: /* ,pci.ci_type_class_code as ci_type_class_code */
532: BULK COLLECT
533: INTO l_ci_id_tbl
534: FROM pa_fp_eligible_ci_v pfc,
535: pa_lookups pal
536: -- ,pa_ci_types_vl pci
537: WHERE pfc.project_id = p_fp_cols_rec.x_project_id
538: AND pfc.fin_plan_type_id = p_fp_cols_rec.x_fin_plan_type_id
539: AND CI_VERSION_TYPE <> decode(p_fp_cols_rec.x_version_type,