PROCEDURE get_cdr_by_filters(p_originating  IN call_data_record.originating_number%TYPE,
                               p_called       IN call_data_record.called_number%TYPE,
                               p_billing_code IN call_data_record.billing_code%TYPE,
                               p_date_from    IN call_data_record.call_start_time%TYPE,
                               p_date_to      IN call_data_record.call_start_time%TYPE,
                               p_file_source IN charging_session.charging_source%TYPE,
                               cur_out        OUT SYS_REFCURSOR,
                               result_code    OUT nts_result_code.code%TYPE) IS
 BEGIN
  result_code := 0;
  OPEN cur_out FOR
    SELECT cs.charging_source, cdr.* FROM call_data_record cdr INNER JOIN charging_session cs ON cdr.charging_session_id = cs.charging_session_id
     WHERE (cdr.originating_number = p_originating OR p_originating IS NULL)
       AND (cdr.called_number = p_called OR p_called IS NULL)
       AND (cdr.billing_code = p_billing_code OR p_billing_code IS NULL)
       AND (cdr.call_start_time BETWEEN p_date_from AND p_date_to OR p_date_from IS NULL OR p_date_to IS NULL)
       AND p_file_source = cs.charging_source
       AND ROWNUM < 10;


  END get_cdr_by_filters;