APPS.FEM_HELPER_RULE_UTIL_PKG SQL Statements

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

Line: 157

   SELECT object_id
   INTO v_rule_object_id
   FROM fem_object_definition_b
   WHERE object_definition_id = p_rule_obj_def_id;

Line: 176

   SELECT object_id
   INTO v_helper_object_id
   FROM fem_object_definition_b
   WHERE object_definition_id = p_helper_obj_def_id;

Line: 196

   SELECT object_type_code
   INTO v_object_type_code
   FROM fem_object_types_vl
   WHERE object_type_code = p_helper_object_type_code;

Line: 215

insert into fem_objdef_helper_rules (OBJECT_DEFINITION_ID,
HELPER_OBJECT_TYPE_CODE,
OBJECT_ID,
HELPER_OBJ_DEF_ID,
HELPER_OBJECT_ID,
CREATION_DATE,
CREATED_BY,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
)
values (p_rule_obj_def_id
,p_helper_object_type_code
,v_rule_object_id
,p_helper_obj_def_id
,v_helper_object_id
,sysdate
,c_user_id
,c_user_id
,sysdate
,c_login_id);

Line: 373

   SELECT object_id
   INTO v_rule_object_id
   FROM fem_object_definition_b
   WHERE object_definition_id = p_rule_obj_def_id;

Line: 394

   SELECT object_type_code
   INTO v_object_type_code
   FROM fem_object_types_vl
   WHERE object_type_code = p_helper_object_type_code;

Line: 415

   SELECT helper_obj_def_id
   INTO x_helper_obj_def_id
   FROM fem_objdef_helper_rules
   WHERE object_definition_id = p_rule_obj_def_id
   AND helper_object_type_code = p_helper_object_type_code;

Line: 425

      SELECT min(helper_obj_def_id)
      INTO x_helper_obj_def_id
      FROM fem_objdef_helper_rules H, fem_object_definition_b D
      WHERE D.object_id = H.object_id
      AND D.object_definition_id = p_rule_obj_def_id
      AND helper_object_type_code = p_helper_object_type_code;