APPS.FEM_ENGINES_PKG SQL Statements

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

Line: 499

      SELECT parameter_numeric_value,
             parameter_char_value,
             parameter_date_value
      INTO   v_param_numeric_value,
             v_param_char_value,
             v_param_date_value
      FROM   fem_pb_parameters
      WHERE  parameter_name = p_parameter_name
      AND    object_type_code = p_object_type_code
      AND    step_name = p_step_name
      AND    object_id = p_object_id;

Line: 511

      SELECT param_data_type_code, param_default_value
      INTO   v_param_data_type, v_param_default_value
      FROM   fem_pb_param_assignmt
      WHERE  parameter_name = p_parameter_name
      AND    object_type_code = p_object_type_code
      AND    step_name = p_step_name
      AND    object_id_level_flag = 'Y';

Line: 531

         SELECT parameter_numeric_value,
                parameter_char_value,
                parameter_date_value
         INTO   v_param_numeric_value,
                v_param_char_value,
                v_param_date_value
         FROM   fem_pb_parameters
         WHERE  parameter_name = p_parameter_name
         AND    object_type_code = p_object_type_code
         AND    step_name = 'ALL'
         AND    object_id = p_object_id;

Line: 543

         SELECT param_data_type_code, param_default_value
         INTO   v_param_data_type, v_param_default_value
         FROM   fem_pb_param_assignmt
         WHERE  parameter_name = p_parameter_name
         AND    object_type_code = p_object_type_code
         AND    step_name = 'ALL'
         AND    object_id_level_flag = 'Y';

Line: 563

            SELECT parameter_numeric_value,
                   parameter_char_value,
                   parameter_date_value
            INTO   v_param_numeric_value,
                   v_param_char_value,
                   v_param_date_value
            FROM   fem_pb_parameters
            WHERE  parameter_name = p_parameter_name
            AND    object_type_code = p_object_type_code
            AND    step_name = p_step_name
            AND    object_id IS NULL;

Line: 575

            SELECT param_data_type_code, param_default_value
            INTO   v_param_data_type, v_param_default_value
            FROM   fem_pb_param_assignmt
            WHERE  parameter_name = p_parameter_name
            AND    object_type_code = p_object_type_code
            AND    step_name = p_step_name
            AND    object_id_level_flag = 'N';

Line: 595

               SELECT parameter_numeric_value,
                      parameter_char_value,
                      parameter_date_value
               INTO   v_param_numeric_value,
                      v_param_char_value,
                      v_param_date_value
               FROM   fem_pb_parameters
               WHERE  parameter_name = p_parameter_name
               AND    object_type_code = p_object_type_code
               AND    step_name = 'ALL'
               AND    object_id IS NULL;

Line: 607

               SELECT param_data_type_code, param_default_value
               INTO   v_param_data_type, v_param_default_value
               FROM   fem_pb_param_assignmt
               WHERE  parameter_name = p_parameter_name
               AND    object_type_code = p_object_type_code
               AND    step_name = 'ALL'
               AND    object_id_level_flag = 'N';