APPS.FPA_PLANNINGCYCLE_PVT dependencies on FPA_PCS_VL

Line 1249: FROM fpa_aw_pc_info_v a, fpa_pcs_vl p

1245:
1246: IF (p_pc_id is null) THEN
1247: SELECT count(p.name)
1248: INTO l_pcName_Count
1249: FROM fpa_aw_pc_info_v a, fpa_pcs_vl p
1250: WHERE a.planning_cycle = p.planning_cycle
1251: AND portfolio = p_portfolio_id
1252: AND p.name = p_pc_name ;
1253: --DBMS_OUTPUT.put_line('Inside pc_id = null');

Line 1257: FROM fpa_aw_pc_info_v a, fpa_pcs_vl p

1253: --DBMS_OUTPUT.put_line('Inside pc_id = null');
1254: ELSE
1255: SELECT count(p.name)
1256: INTO l_pcName_Count
1257: FROM fpa_aw_pc_info_v a, fpa_pcs_vl p
1258: WHERE a.planning_cycle = p.planning_cycle
1259: AND portfolio = p_portfolio_id
1260: AND p.name = p_pc_name
1261: AND a.planning_cycle <> p_pc_id ;