APPS.FEM_BR_STAT_LOOKUP_PVT SQL Statements

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

Line: 7

PROCEDURE DeleteObjectDefinition(p_obj_def_id NUMBER) IS
BEGIN

    -- First delete the Lookup join.
     DELETE FROM fem_stat_lookup_rel WHERE STAT_LOOKUP_OBJ_DEF_ID = p_obj_def_id;

Line: 13

     DELETE FROM fem_stat_lookups WHERE STAT_LOOKUP_OBJ_DEF_ID = p_obj_def_id;

Line: 18

    FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, 'DeleteObjectDefinition');

Line: 30

    INSERT INTO fem_stat_lookups( stat_lookup_obj_def_id,
                                  stat_lookup_table,
                                  related_to_table,
                                  stat_lookup_column,
                                  condition_obj_def_id,
                                  created_by,
                                  creation_date,
                                  last_updated_by,
                                  last_update_date,
                                  last_update_login,
                                  object_version_number)
                                  SELECT p_target_obj_def_id,
                                         stat_lookup_table,
                                         related_to_table,
                                         stat_lookup_column,
                                         condition_obj_def_id,
                                         p_created_by,
                                         p_creation_date,
                                         FND_GLOBAL.user_id,
                                         SYSDATE,
                                         FND_GLOBAL.login_id,
                                         0
                                  FROM fem_stat_lookups
                                  WHERE stat_lookup_obj_def_id = p_source_obj_def_id;

Line: 56

     INSERT INTO fem_stat_lookup_rel( stat_lookup_obj_def_id,
                                      stat_lookup_tbl_col,
                                      relational_operand,
                                      related_to_tbl_col,
                                      value,
                                      created_by,
                                      creation_date,
                                      last_updated_by,
                                      last_update_date,
                                      last_update_login,
                                      object_version_number)
                                  SELECT p_target_obj_def_id,
                                         stat_lookup_tbl_col,
                                         relational_operand,
                                         related_to_tbl_col,
                                         value,
                                         p_created_by,
                                         p_creation_date,
                                         FND_GLOBAL.user_id,
                                         SYSDATE,
                                         FND_GLOBAL.login_id,
                                         0
                                  FROM fem_stat_lookup_rel
                                  WHERE stat_lookup_obj_def_id = p_source_obj_def_id;