APPS.FEM_DS_WHERE_CLAUSE_GENERATOR SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

         SELECT
               tc.table_classification_code
            FROM
               fem_table_class_assignmt tc
            WHERE
                     tc.table_name = X_Table_Name
               and   tc.table_classification_code = 'DATASET_IO_WCLAUSE';

Line: 381

         select
               a.object_name
               ,b.folder_name
            from
               fem_object_definition_b c
               ,fem_object_catalog_vl a
               ,fem_folders_vl b
            where
                     c.object_definition_id = p_DS_IO_Def_ID
               and   c.object_id = a.object_id
               and   b.folder_id = a.folder_id;

Line: 451

         select
               Dimension_Group_Name
            from
               Fem_Dimension_Grps_Vl
            where Dimension_Group_ID = p_Dim_Group_ID;

Line: 513

         select
               Dataset_Name
            from
               Fem_Datasets_Vl
            where Dataset_Code = p_Dataset_Code;

Line: 574

         select
               Cal_Period_Name
            from
               Fem_Cal_Periods_Vl
            where cal_Period_id = p_Cal_Period_ID;

Line: 749

         Select
               a.INPUT_DATASET_CODE
               ,b.DATASET_NAME
               ,a.ABSOLUTE_CAL_PERIOD_FLAG
               ,a.ABSOLUTE_CAL_PERIOD_ID
               ,c.CAL_PERIOD_NAME
               ,a.RELATIVE_DIMENSION_GROUP_ID
               ,d.dimension_group_name
               ,a.RELATIVE_CAL_PERIOD_OFFSET
            from
                FEM_DS_INPUT_LISTS a
               ,FEM_DATASETS_VL b
               ,FEM_CAL_PERIODS_TL c
               ,FEM_DIMENSION_GRPS_TL d
            where
                   a.DATASET_IO_OBJ_DEF_ID = p_DS_IO_Def_ID
               and a.INPUT_DATASET_CODE = b.DATASET_CODE
               and a.ABSOLUTE_CAL_PERIOD_ID= c.CAL_PERIOD_ID(+)
               and c.language(+) = USERENV('LANG')
               and a.relative_dimension_group_id = d.dimension_group_id(+)
               and d.language(+) = USERENV('LANG');

Line: 1040

         Select
            a.output_dataset_code
         from
            fem_ds_input_output_defs a
         where
            a.DATASET_IO_OBJ_DEF_ID = p_DSGroup_Def_ID;

Line: 1301

      z_No_Eff_Cal_Entries_Tab.DELETE;

Line: 1304

      z_Dup_Entries_Tab.DELETE;