APPS.FPA_PORTFOLIO_PROJECT_SETS_PVT dependencies on FPA_PCS_VL

Line 25: l_pc_name fpa_pcs_vl.NAME%TYPE;

21: l_project_set_id fpa_aw_project_sets_v.init_project_set_id%TYPE;
22: l_appr_scen_id fpa_aw_sce_info_v.scenario%TYPE;
23: l_project_id_tbl SYSTEM.pa_num_tbl_type;
24: l_portfolio_name fpa_portfs_vl.name%TYPE;
25: l_pc_name fpa_pcs_vl.NAME%TYPE;
26: -- l_pset_attr fpa_project_sets_v.status%TYPE;
27: -- l_count number;
28:
29: l_count number(15);

Line 191: FROM fpa_pcs_vl

187:
188: --Select pc name, to be part of the project_set name.
189: SELECT name
190: INTO l_pc_name
191: FROM fpa_pcs_vl
192: WHERE planning_cycle = p_pc_id;
193:
194: --Coin the ProjectSet name.
195: l_project_set_name := l_portfolio_name||' - '||l_pc_name||' - ';