DBA Data[Home] [Help]

APPS.FEM_DIM_HIER_LOADER_PKG dependencies on FEM_OBJECT_CATALOG_VL

Line 688: FROM fem_object_catalog_vl o

684: SELECT object_definition_id
685: INTO g_hier_object_def_id
686: FROM fem_object_definition_vl d
687: WHERE d.object_id in (SELECT o.object_id
688: FROM fem_object_catalog_vl o
689: WHERE o.object_type_code = 'HIERARCHY_LOADER'
690: AND o.folder_id in (SELECT f.folder_id
691: FROM fem_user_folders f
692: WHERE f.user_id = fnd_global.user_id)

Line 739: fem_object_catalog_vl focb,

735: fht.hier_obj_def_display_name,
736: TO_NUMBER(NULL),
737: gs_table_row_tab(i)
738: FROM fem_hierarchies_t fht,
739: fem_object_catalog_vl focb,
740: fem_object_definition_vl fodb
741: WHERE fht.dimension_varchar_label = gs_hier_dim_label_tab(i)
742: AND fht.hierarchy_object_name = focb.object_name
743: AND focb.object_id = gs_hier_obj_id_tab(i)

Line 766: fem_object_catalog_vl focb,

762: TO_NUMBER(NULL),
763: gs_table_row_tab(i)
764: FROM fem_hierarchies_t fht,
765: fem_hierarchies fh,
766: fem_object_catalog_vl focb,
767: fem_object_definition_vl fodb
768: WHERE fht.dimension_varchar_label = gs_hier_dim_label_tab(i)
769: AND fht.hierarchy_object_name = focb.object_name
770: AND focb.object_id = fh.hierarchy_obj_id