DBA Data[Home] [Help]

APPS.FPA_UTILS_PVT dependencies on PA_CLASS_CATEGORIES

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 693: l_inv_cat_name pa_class_categories.class_category%type;

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;
694:
695: begin
696: open c_inv_cat_name;
697: fetch c_inv_cat_name into l_inv_cat_name;