APPS.FPA_PLANNINGCYCLE_PVT dependencies on FPA_PCS_VL

Line 1229: FROM fpa_aw_pc_info_v a, fpa_pcs_vl p

1225:
1226: IF (p_pc_id is null) THEN
1227: SELECT count(p.name)
1228: INTO l_pcName_Count
1229: FROM fpa_aw_pc_info_v a, fpa_pcs_vl p
1230: WHERE a.planning_cycle = p.planning_cycle
1231: AND portfolio = p_portfolio_id
1232: AND p.name = p_pc_name ;
1233: --DBMS_OUTPUT.put_line('Inside pc_id = null');

Line 1237: FROM fpa_aw_pc_info_v a, fpa_pcs_vl p

1233: --DBMS_OUTPUT.put_line('Inside pc_id = null');
1234: ELSE
1235: SELECT count(p.name)
1236: INTO l_pcName_Count
1237: FROM fpa_aw_pc_info_v a, fpa_pcs_vl p
1238: WHERE a.planning_cycle = p.planning_cycle
1239: AND portfolio = p_portfolio_id
1240: AND p.name = p_pc_name
1241: AND a.planning_cycle <> p_pc_id ;