APPS.FPA_UTILS_PVT dependencies on FPA_AW_PC_INFO_V

Line 170: from fpa_aw_pc_info_v

166:
167: --Select current pc status
168: select pc_status
169: into l_pc_status
170: from fpa_aw_pc_info_v
171: where planning_cycle = p_pc_id;
172:
173: CASE
174: when l_pc_status is null then

Line 498: select 'VALID' from fpa_aw_pc_info_v

494:
495: -- cursor to check if GL Calendar has been loaded for any other planning cycle.
496:
497: cursor c_cal_per_type_valid is
498: select 'VALID' from fpa_aw_pc_info_v
499: where calendar_name = p_calendar_name
500: and period_type = p_period_type and pc_status <> 'CREATED' and rownum < 2;
501:
502: l_valid varchar2(30);

Line 689: select class_category from pa_class_categories pac, fpa_aw_pc_info_v pci

685: p_planning_cycle_id in number,
686: x_inv_category_name out nocopy varchar2
687: ) is
688: cursor c_inv_cat_name is
689: select class_category from pa_class_categories pac, fpa_aw_pc_info_v pci
690: where pac.class_category_id = pci.pc_category
691: and pci.planning_cycle = p_planning_cycle_id;
692:
693: l_inv_cat_name pa_class_categories.class_category%type;

Line 761: select NVL(currency_code,NULL) into l_unit from fpa_aw_pc_info_v

757:
758: BEGIN
759:
760: if p_metric_code = 'NPV' then
761: select NVL(currency_code,NULL) into l_unit from fpa_aw_pc_info_v
762: where planning_cycle = p_planning_cycle_id;
763: else
764: select NVL(meaning,NULL) into l_unit from fpa_lookups_V
765: where lookup_type ='FPA_UNITS'